Bug 141956 - CALC: EXCEL compatibility issue for xls files containing checkboxes
Summary: CALC: EXCEL compatibility issue for xls files containing checkboxes
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.2.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-04-29 06:30 UTC by qve00761
Modified: 2021-05-07 08:23 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
XLS with a checkbox made by LO Calc 7.2 (5.50 KB, application/vnd.ms-excel)
2021-05-04 14:19 UTC, Roman Kuznetsov
Details
File with check box that cannot be read by EXCEL (150.00 KB, application/vnd.ms-excel)
2021-05-07 07:12 UTC, qve00761
Details

Note You need to log in before you can comment on or make changes to this bug.
Description qve00761 2021-04-29 06:30:08 UTC
Description:
When creating a checkbox (Form Control) in LibreOffice, if you save it in xls and open it in Microsoft EXCEL, the file is corrupted and cannot be read normally.


Steps to Reproduce:
1.Open a calc spreadsheet and create some checkboxes
2.Save as xls
3.Open it in Microsoft EXCEL, the file is corrupted and cannot be read normally.

Actual Results:
Xls files is corrupted

Expected Results:
When I open an xls file in Excel, the file containing the Checkbox is displayed normally. 


Reproducible: Always


User Profile Reset: No



Additional Info:
This behavior does not occur in Version 6.4.4.2.

If you reopen this file in LibreOffice 7.1.2.2, it will load normally.
Comment 1 Roman Kuznetsov 2021-05-04 14:18:19 UTC
No problem in

Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 931e264590100c555580c413556e229a0f03316a
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: threaded
Comment 2 Roman Kuznetsov 2021-05-04 14:19:27 UTC
Created attachment 171632 [details]
XLS with a checkbox made by LO Calc 7.2
Comment 3 qve00761 2021-05-07 07:12:53 UTC
Created attachment 171730 [details]
File with check box that cannot be read by EXCEL

This file was created in LibreOffice 7.1.2.2.
This file can be read successfully in LibreOffice 7.1.2.2,
It cannot be read by EXCEL.
Comment 4 qve00761 2021-05-07 07:16:28 UTC
UPDATE from checkbox7.1.2.2 to checkbox7.1.3.2.
When I saved the file containing the checkbox with xls,
I was able to read it with EXCEL.

Thank You.