Bug 165693 - FILESAVE XLSX Checkbox form control seen as double in Excel
Summary: FILESAVE XLSX Checkbox form control seen as double in Excel
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks: XLSX-Form-Controls
  Show dependency treegraph
 
Reported: 2025-03-11 16:35 UTC by Gabor Kelemen (allotropia)
Modified: 2025-03-11 16:55 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
The original and the saved example files in Excel, after moving the top CB in the Calc-saved version (42.82 KB, image/png)
2025-03-11 16:35 UTC, Gabor Kelemen (allotropia)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2025-03-11 16:35:56 UTC
Created attachment 199738 [details]
The original and the saved example files in Excel, after moving the top CB in the Calc-saved version

This is a followup to bug 165607 and bug 165609 

When the example file from bug 165607 (attachment 199653 [details]) is saved in Calc as XLSX ( attachment 199654 [details] ) and opened in Excel, somehow it thinks there are two checkbox form controls in the file, overlapping each other. 
One of them is the one with white background from bug 165609, the other is below it and it has transparent background.

1. Open attachment 199653 [details]
2. Save it as XLSX
3. Open the resulting file attachment 199654 [details] in Excel 
4. Right click on the checkbox in the green cell to highlight it, and move it down with the arrow key
-> there is another checkbox hiding below it! Clicking on one of them toggles the status of the other as well.

Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 894563ee0e4032019623a97c313af3d833863b1f
CPU threads: 14; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: threaded

Seems to have started in 7.3 with:

https://git.libreoffice.org/core/+/94678a7b9c6b7e577c15adacc885e03551bcf17b%5E%21

commit 94678a7b9c6b7e577c15adacc885e03551bcf17b	[log]
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
tree 1e48aea7c4b61cfa8e1f06c9a4d7aa95d25745db
parent 7cbd6d768d282077053c354254315f3dc89bf254 [diff]

XLSX export: improve handling of checkbox (form controls)

This builds on top of commit fd238380ae7820f12ac1f7c52d0f7180a93f3ba3
(tdf#106181 XLSX export: output form controls, 2020-05-13) and adds the
missing VML version which seems to be mandated by Excel 2019.