Bug 165607 - FILESAVE XLSX Checkbox background color changes from Default to White
Summary: FILESAVE XLSX Checkbox background color changes from Default to White
Status: NEW
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:
Depends on:
Blocks: XLSX-Form-Controls
  Show dependency tree / graph
 
Reported: 2025-03-06 13:29 UTC by Gabor Kelemen (allotropia)
Modified: 2025-03-11 16:35 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Example file from Excel 2016 (10.68 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2025-03-06 13:29 UTC, Gabor Kelemen (allotropia) 		Details
The example file saved with Calc (8.51 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2025-03-06 13:30 UTC, Gabor Kelemen (allotropia) 		Details
The example file in Excel and Calc - good (111.05 KB, image/png)
2025-03-06 13:33 UTC, Gabor Kelemen (allotropia) 		Details
The saved and reloaded file in Calc - white rectangle on green background (118.83 KB, image/png)
2025-03-06 13:35 UTC, Gabor Kelemen (allotropia) 		Details
View All 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 Gabor Kelemen (allotropia) 2025-03-06 13:29:59 UTC 
Created attachment 199653 [details]
Example file from Excel 2016

As spotted in bug #143328 comment10

When a checkbox form control in an XLSX file is roundtripped, its default background color changes from Default (No fill in Excel) to White. This can cover other content of the file, such as text in the same cell.

1. Open attached document in Calc
2. Save as XLSX
3. Open it in Excel or Calc
-> the checkbox covers a white rectangle on the green cell background.
Comment 1 Gabor Kelemen (allotropia) 2025-03-06 13:30:41 UTC 
Created attachment 199654 [details]
The example file saved with Calc

Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 36a6bf8bd65e2ece92a4354e9f6d8e47e0f03d84
CPU threads: 14; OS: Windows 10 X86_64 (build 19045); UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: threaded
Comment 2 Gabor Kelemen (allotropia) 2025-03-06 13:33:51 UTC 
Created attachment 199655 [details]
The example file in Excel and Calc - good
Comment 3 Gabor Kelemen (allotropia) 2025-03-06 13:35:16 UTC 
Created attachment 199656 [details]
The saved and reloaded file in Calc - white rectangle on green background
Comment 4 raal 2025-03-09 07:57:55 UTC 
Confirm with Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 7c806a668530f25730717a12e6f97972f69d9c09
CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded