Bug 106181 - FILESAVE: Check boxes get lost when saving as .XLSX
Summary: FILESAVE: Check boxes get lost when saving as .XLSX
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: filter:xlsx
: 106726 (view as bug list)
Depends on:
Blocks: XLSX
  Show dependency treegraph
Reported: 2017-02-24 20:41 UTC by Johannes Schneider
Modified: 2019-11-18 03:18 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

spreadsheet in .XLSX format containing the bug (5.45 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-02-24 23:08 UTC, Johannes Schneider
spreadsheet in .ODS format, working properley (10.84 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-02-24 23:09 UTC, Johannes Schneider

Note You need to log in before you can comment on or make changes to this bug.
Description Johannes Schneider 2017-02-24 20:41:59 UTC
When I create a check box in a spread sheet and then save the file in the format "Microsoft Excel 7 - 2013 XML (.XLSX)", the check box is disappeared after closing and reopening the file. Obviously calc doesn' t save check boxes in this format.
Comment 1 tommy27 2017-02-24 20:49:13 UTC
please post a test file where you exactly replicate your bug.
Comment 2 Johannes Schneider 2017-02-24 23:08:27 UTC
Created attachment 131460 [details]
spreadsheet in .XLSX format containing the bug
Comment 3 Johannes Schneider 2017-02-24 23:09:35 UTC
Created attachment 131461 [details]
spreadsheet in .ODS format, working properley
Comment 4 tommy27 2017-02-25 04:26:36 UTC
I confirm bug in LibO and (*)

the issue is not new and is already present in LibO as well.
I did not test earlier releases.

status NEW

(*) Build ID: 5bb5a9dacb84ec14f7148a5a5d9ba38b7e9f1039
CPU Threads: 4; OS Version: Windows 6.29; UI Render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2017-02-17_23:30:45
Locale: it-IT (it_IT); Calc: group
Comment 5 m.a.riosv 2017-02-26 01:23:51 UTC
Looks like a dup, please if you are not agree reopen it.

*** This bug has been marked as a duplicate of bug 69098 ***
Comment 6 Johannes Schneider 2017-03-01 21:10:53 UTC
In bug 69098 writer does not show check boxes in a word document, word does. It looks like the reverse problem.
What I found is that calc does not save the check boxes with the document when saving it in .XLSX format. It is about saving, not about file-opening or rendering.
Comment 7 m.a.riosv 2017-03-23 22:46:10 UTC
*** Bug 106726 has been marked as a duplicate of this bug. ***
Comment 8 Aron Budea 2017-10-02 01:52:29 UTC
Exporting form controls has been recently implemented in DOCX format (bug 50097), with the following commit:

Likely something similar has to be done in case of XLSX files.
Comment 9 Côme Desplats 2018-06-15 07:43:37 UTC
The bug is still present in LibreOffice
Comment 10 QA Administrators 2019-06-16 02:57:16 UTC Comment hidden (obsolete)
Comment 11 Johannes Schneider 2019-06-16 15:09:26 UTC
The bug still (ore again) exists in Version (x64)
As far as I remember it had been resolved in one of the versions since then.

The bug also occured in the versions 3.3 and
(I tested using the portable versions. During the installation there happened some complaints because I have no java runtime.)

Version: (x64)
Build ID: 5896ab1714085361c45cf540f76f60673dd96a72
CPU threads: 4; OS: Windows 6.1; UI render: default; 
Locale: de-DE (de_DE); Calc: group threaded