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.
please post a test file where you exactly replicate your bug.
Created attachment 131460 [details] spreadsheet in .XLSX format containing the bug
Created attachment 131461 [details] spreadsheet in .ODS format, working properley
I confirm bug in LibO 5.2.5.1 and 5.4.0.0.alpha0+ (*) the issue is not new and is already present in LibO 4.0.1.2 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
Looks like a dup, please if you are not agree reopen it. *** This bug has been marked as a duplicate of bug 69098 ***
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.
*** Bug 106726 has been marked as a duplicate of this bug. ***
Exporting form controls has been recently implemented in DOCX format (bug 50097), with the following commit: https://cgit.freedesktop.org/libreoffice/core/commit/?id=c0cc02e2934aeb12dda44818955e5964496c186a Likely something similar has to be done in case of XLSX files.
The bug is still present in LibreOffice 6.0.4.2.
Dear Johannes Schneider, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
The bug still (ore again) exists in Version 6.1.6.3 (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 6.2.4.2. (I tested using the portable versions. During the installation there happened some complaints because I have no java runtime.) Version: 6.1.6.3 (x64) Build ID: 5896ab1714085361c45cf540f76f60673dd96a72 CPU threads: 4; OS: Windows 6.1; UI render: default; Locale: de-DE (de_DE); Calc: group threaded
Serge Krot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/fd238380ae7820f12ac1f7c52d0f7180a93f3ba3 tdf#106181 XLSX export: output form controls It will be available in 7.0.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Serge Krot committed a patch related to this issue. It has been pushed to "libreoffice-6-4": https://git.libreoffice.org/core/commit/577dd32b1c4eb0a4cff574fbabca987cb52b831b tdf#106181 XLSX export: output form controls It will be available in 6.4.5. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Using the ods attach, the file is still reproducible in Version: 7.1.0.0.alpha0+ Build ID: 7df1884118a0d995ec57679ef83e586c95063858 CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded checkbox is gone after roundtripping the file to XLSX
The checkbox for attached sample is being saved into XLSX file correctly - You could verify it by opening the file with MS Excel for example. Import of form controls from XLSX is too big topic to mix it here with export function. => Please, open new tickets
New issue was created tdf#135987
So yep, the checkbox info is now properly saved to XLSX. Sadly, the load part of our XLSX filter is not handling this properly yet, see bug 135987 for that.
(In reply to Serge Krot (CIB) from comment #15) > The checkbox for attached sample is being saved into XLSX file correctly - > You could verify it by opening the file with MS Excel for example. > > Import of form controls from XLSX is too big topic to mix it here with > export function. => Please, open new tickets oh, I see, thanks for the clarification and for creating the new ticket. I plan to create a unittest for this issue
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/3696b51de1a4075f99fea6ea4e20ad4949188117 tdf#106181: sc_subsequent_export_test: Add unittest It will be available in 7.1.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Should this work in 7.1.0.1? I tried the files on Kubuntu 20.04 with LibreOffice 7.1.0.1 and xlsx still fails while ods works.
(In reply to Silicomancer from comment #20) > Should this work in 7.1.0.1? I tried the files on Kubuntu 20.04 with > LibreOffice 7.1.0.1 and xlsx still fails while ods works. See comment 15.
Justin Luth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/a3c5c0f7ce73001adab7475fde1f8ffec4eef48b tdf#139786 partial revert tdf#106181 XLSX export: output form controls It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Justin Luth committed a patch related to this issue. It has been pushed to "libreoffice-7-1": https://git.libreoffice.org/core/commit/4d63b046679539c1e0f5a6f44e87c9420d679f5b tdf#139786 partial revert tdf#106181 XLSX export: output form controls It will be available in 7.1.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Justin Luth committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/babd187dfaa5181ddaec6612fb8efe12ac8ed350 tdf#139786 partial revert tdf#106181 XLSX export: output form controls It will be available in 7.0.6. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Created attachment 171745 [details] There are still cases where checkboxes are lost. If the checkbox is not linked to a cell, the checkbox disappears when you save it in xlsx format. tried it with LO7.2.0.0 Alpha.
(In reply to qve00761 from comment #25) > Created attachment 171745 [details] > There are still cases where checkboxes are lost. > > If the checkbox is not linked to a cell, > the checkbox disappears when you save it in xlsx format. > > tried it with LO7.2.0.0 Alpha. This issue registered the ticket as 142209.