Bug 122093 - FILESAVE XLSX: ConditionalStyle with "automatic" font color changes to "white", affecting Conditional formatting
Summary: FILESAVE XLSX: ConditionalStyle with "automatic" font color changes to "white...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Conditional-Formatting
  Show dependency treegraph
 
Reported: 2018-12-14 11:28 UTC by NISZ LibreOffice Team
Modified: 2024-01-05 16:31 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
The original spreadsheet. (25.31 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-12-14 11:28 UTC, NISZ LibreOffice Team
Details
The saved spreadsheet. (26.26 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-12-14 11:29 UTC, NISZ LibreOffice Team
Details
Screenshot of the original and exported document side by side in Calc. (303.45 KB, image/png)
2018-12-14 11:29 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2018-12-14 11:28:05 UTC
Description:
When the attached spreadsheet gets saved in LO some of the conditional formatting format changes its text color form black to white.

Steps to Reproduce:
    1. Open the attached spresdsheet in LO.
    2. Save it as xlsx.
    3. Reload.
    4. Go to Format→ Conditional→ Manage and check the rules.

Actual Results:
The rules that got a blue background has a white text color.

Expected Results:
They should keep their original black textcolor.


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 NISZ LibreOffice Team 2018-12-14 11:28:36 UTC
Created attachment 147522 [details]
The original spreadsheet.
Comment 2 NISZ LibreOffice Team 2018-12-14 11:29:03 UTC
Created attachment 147523 [details]
The saved spreadsheet.
Comment 3 NISZ LibreOffice Team 2018-12-14 11:29:20 UTC
Created attachment 147524 [details]
Screenshot of the original and exported document side by side in Calc.
Comment 4 Durgapriyanka 2018-12-14 18:48:26 UTC
Thank you for reporting the bug. I can confirm that the bug is present in

Version: 6.3.0.0.alpha0+
Build ID: 3c964980da07892a02d5ac721d80558c459532d0
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-12-12_02:07:45
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
Comment 5 Xisco Faulí 2018-12-18 13:44:08 UTC
Also reproduced in

Version: 5.3.0.0.alpha1+
Build ID: 4136757b4e51c4e6f7cb4132c95538a7f831ef2c
CPU Threads: 4; OS Version: Linux 4.15; UI Render: default; VCL: gtk3; Layout Engine: new; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group

In previous versions, the conditional formatting wasn't even exported...
Comment 6 Xisco Faulí 2019-08-21 10:20:31 UTC
Still reproducible in

Version: 6.4.0.0.alpha0+
Build ID: 2bed8af91fc2654b9ed2432f969d32d5741a529b
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded
Comment 7 Justin L 2022-10-26 20:58:00 UTC
repro 7.5+
Contrary to the title, the font in the light-blue square is turning white, not black.