Bug 142209 - FILE SAVE:CALC: EXCEL compatibility issue for xlsx files containing checkboxes
Summary: FILE SAVE:CALC: EXCEL compatibility issue for xlsx files containing checkboxes
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX-Form-Controls
  Show dependency treegraph
 
Reported: 2021-05-11 04:19 UTC by qve00761
Modified: 2021-05-13 07:47 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
Checkbox not linked to cell (36.81 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-05-11 04:23 UTC, qve00761
Details
The original file in Calc and its XLSX version in Excel (150.58 KB, image/png)
2021-05-11 07:17 UTC, NISZ LibreOffice Team
Details
Setting a cell link to the second box makes it appear in Excel after saving as xlsx (141.84 KB, image/png)
2021-05-11 07:29 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description qve00761 2021-05-11 04:19:53 UTC
Description:
Description:
When creating a checkbox (Form Control) in LibreOffice, if you save it in xlsx and open it in Microsoft EXCEL, Checkboxes are lost.

It has been fixed by Bug 106181, but there are still cases where it cannot be dealt with. 
Checkboxes that are not linked to cells are lost when saved in xlsx format.


Steps to Reproduce:
1.Open by CALC and create some checkboxes
2.Do not link checkboxes to cells. 
3.Save as xlsx
4.Open it in Microsoft EXCEL. Checkboxes are lost.


Actual Results:
Checkboxes that are not linked to cells are lost when saved in xlsx format.

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


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.2.0.0.alpha0+ (x86) / LibreOffice Community
Build ID: 9df3aa7ea72d61462e430643f2a80906dce4e15b
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: en-US
Calc: threaded
Comment 1 qve00761 2021-05-11 04:23:13 UTC
Created attachment 171860 [details]
Checkbox not linked to cell

Please save the attached file in xlsx format.
The second checkbox disappears.
Comment 2 NISZ LibreOffice Team 2021-05-11 07:17:19 UTC
Created attachment 171861 [details]
The original file in Calc and its XLSX version in Excel

Confirming the disappearance of the second box with:

Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: d7f734db2c078ced3ce08ad58cd816a79abe3bcf
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL
Comment 3 NISZ LibreOffice Team 2021-05-11 07:29:58 UTC
Created attachment 171862 [details]
Setting a cell link to the second box makes it appear in Excel after saving as xlsx
Comment 4 Xisco Faulí 2021-05-11 07:33:36 UTC
Also reproduced in

Version: 5.4.0.0.alpha1+
Build ID: 9feb7f7039a3b59974cbf266922177e961a52dd1
CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); Calc: group

and

Version: 5.2.0.0.alpha0+
Build ID: 7b9a5e8124328da9d81aed58cf944c91560a7c07
CPU Threads: 4; OS Version: Linux 5.7; UI Render: default; 
Locale: en-US (en_US.UTF-8)
Comment 5 Xisco Faulí 2021-05-11 07:36:08 UTC
Is this a dupe of bug 113610 ?
Comment 6 Xisco Faulí 2021-05-11 07:43:55 UTC

*** This bug has been marked as a duplicate of bug 113610 ***
Comment 7 NISZ LibreOffice Team 2021-05-13 07:47:31 UTC
(In reply to Xisco Faulí from comment #5)
> Is this a dupe of bug 113610 ?

Nope.

That one is about losing a checkbox after saving an Excel-made file in Calc, then reloading in Calc, while it is present in Excel -> Import error.

This one is about losing a checkbox not linked to a cell when saved by Calc, then opening in Excel -> Export error.