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
Created attachment 171860 [details] Checkbox not linked to cell Please save the attached file in xlsx format. The second checkbox disappears.
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
Created attachment 171862 [details] Setting a cell link to the second box makes it appear in Excel after saving as xlsx
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)
Is this a dupe of bug 113610 ?
*** This bug has been marked as a duplicate of bug 113610 ***
(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.
Created attachment 185054 [details] The example file exported with 7.3 in Excel 2016 This got better in 7.3 with: https://git.libreoffice.org/core/+/94678a7b9c6b7e577c15adacc885e03551bcf17b author Miklos Vajna <vmiklos@collabora.com> Wed Jun 30 16:22:42 2021 +0200 committer Miklos Vajna <vmiklos@collabora.com> Wed Jun 30 20:33:39 2021 +0200 XLSX export: improve handling of checkbox (form controls) Now the second checkbox is also exported and visible in Excel 2010/13/16. (and became visible in Calc as well recently, see: https://bugs.documentfoundation.org/show_bug.cgi?id=143328#c9)
Thanks Miklos for fixing this! (Don't worry about the highlighted Cell link on the image, that was lost in 7.3 but got fixed in master)