Bug 122093 - FILESAVE XLSX, Conditional formatting with "automatic" font color changes to "black"
Summary: FILESAVE XLSX, Conditional formatting with "automatic" font color changes to ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Conditional-Formatting
  Show dependency treegraph
Reported: 2018-12-14 11:28 UTC by NISZ LibreOffice Team
Modified: 2021-01-04 09:22 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

The original spreadsheet. (25.31 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-12-14 11:28 UTC, NISZ LibreOffice Team
The saved spreadsheet. (26.26 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-12-14 11:29 UTC, NISZ LibreOffice Team
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

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
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

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

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

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