Bug 135436 - Checkboxes disappear after saving xlsx file in Libre office 7
Summary: Checkboxes disappear after saving xlsx file in Libre office 7
Status: RESOLVED DUPLICATE of bug 135987
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.0.4 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX-Form-Controls
  Show dependency tree / graph
 
Reported: 2020-08-04 14:13 UTC by Martin Hodek
Modified: 2020-10-06 11:40 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Martin Hodek 2020-08-04 14:13:16 UTC 
Description:
Checkboxes disappear after saving xlsx file in Libre office 7. Bug refers to this bug: https://bugs.documentfoundation.org/show_bug.cgi?id=134769. More in another comment.


Steps to Reproduce:
1.open submitted bug in current version of LO 7
2. edit it any way you like (list called "dotazník"
3. save the file
4. open the file in MSO

Actual Results:
Checkboxes disappear.

Expected Results:
Checkboxes should stay visible and editable.


Reproducible: Always


User Profile Reset: No



Additional Info:
Bug refers to this bug: https://bugs.documentfoundation.org/show_bug.cgi?id=134769. More in another comment.

Version: 7.0.1.0.0+ (x64)
Build ID: <buildversion>
CPU threads: 12; OS: Windows 10.0 Build 18363; UI render: Skia/Vulkan; VCL: win
Locale: cs-CZ (cs_CZ); UI: cs-CZ
Calc: CL
Comment 1 Martin Hodek 2020-08-04 14:21:33 UTC 
I have a xlsx file that works as a questionnaire.
It contains checkboxes. In previous versions of LibreOffice (6.4 and earlier) those checkboxes disappeared after saving the file in LO in xlsx format, but information from these checkboxes remained accessible in linked cells.
After updating LO to ver. 7 RC1 checkboxes remained visible and editable after saving the file and opening it again in LO 7 RC1, but it was not possible to open the file in MSO, MSO considered it corrupted.
The bug was reported and fixed. It is now possible (tested in LibreOfficeDev_7.0.1.0.0_Win_x64.msi from 2020-Jul-31 21:01) to save xlsx file in LO and than open it in MSO (tested in MSO 2016). But situation with checkboxes reverted to the previous state (LO 6.4 and earlier) - after saving the file in xlsx format in LO 7 checkboxes now once again disappear.

Thank you in advance for your help.

Martin Hodek
Comment 2 Martin Hodek 2020-08-04 14:28:14 UTC 
I am terribly sorry, but my home computer seems not to be able to upload attachments (poor internet connection). Please, use attachments from the reference bellow, it is the same file.

Thank you

Martin Hodek

ttps://bugs.documentfoundation.org/show_bug.cgi?id=134769
Comment 3 Telesto 2020-08-05 09:05:06 UTC 
Repro with
7.1

Version: 6.0.5.0.0+
Build ID: 15ea1cda0b3c37ff944ad9a239b7ed453e8b0591
CPU threads: 4; OS: Windows 6.3; UI render: default; 
Locale: nl-NL (nl_NL); Calc: CL

and with
4.4.7.2

and with
4.2
Comment 4 NISZ LibreOffice Team 2020-10-06 11:40:18 UTC 
There is another bug on this disappearing checkbox topic.

*** This bug has been marked as a duplicate of bug 135987 ***