Description: Checked checkboxes (not linked to any cell) in xlsx are not checked when reopened. Steps to Reproduce: 1. Create a new sheet. 2. Create a checkbox. 3. Click the checkbox. (or change its default status) 4. Save as XLSX. (and ODS too) 5. Open it again. Actual Results: All checkboxes are unchecked in XLSX. Expected Results: Status should be saved in XLSX too. Reproducible: Always User Profile Reset: No Additional Info: maybe related to https://bugs.documentfoundation.org/show_bug.cgi?id=142209 Locale: ja Module: SpreadsheetDocument OS: Windows 10 OS is 64bit: yes
Created attachment 194490 [details] xlsx with checkbox
Reproducible Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 6084962f93efc005b6827edceae12d3170f17ccd CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
FWIW, it works correctly for the older XLS format. The same behavior as described in comment 0 is seen in LO 7.6, but in LO 7.5 and older the complete checkbox itself disappears when saving as XLSX.
Also in Version: 24.2.3.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: ro-RO Ubuntu package version: 4:24.2.3-0ubuntu0.24.04.2 Calc: threaded
I am not sure that we need a bibisect for this. Until LO 7.5 this was even worse; in 7.6 there was some partial improvement; XLS is OK (XLSX, KO). See comment 3. If someone thinks that bibisectRequest is relevant, please add it.