https://bugs.documentfoundation.org/show_bug.cgi?id=170398
Bug ID: 170398
Summary: Conditional formatting does not override the font
color of negative numbers when an Excel file is opened
with LibreOffice
Product: LibreOffice
Version: 25.8.3.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When opening an Excel file (.xlsx) in LibreOffice Calc, conditional formatting
does not fully override the number format styling applied in Excel.
Steps to Reproduce:
1.Create a new file in Microsoft Excel.
2.Set a cell to Number format where negative numbers are displayed in red font.
3.Enter a negative numeric value in the cell.
4. Apply conditional formatting to the same cell:
- Condition: value < 0
- Background color: red
- Font color: white
5. Save the file as .xlsx.
6. Open the file in LibreOffice Calc.
Actual Results:
- The conditional formatting background color (red) is applied correctly.
- The font color remains red, inherited from the number format for negative
values.
As a result, the text is red on a red background, making it hard to read.
Expected Results:
- Conditional formatting should override the number format font color, as it
does in Microsoft Excel.
- The text color should be white, matching the conditional formatting rule.
Reproducible: Always
User Profile Reset: No
Additional Info:
- Microsoft Excel correctly applies the conditional formatting (red background
with white text).
This issue affects interoperability with Excel files that rely on conditional
formatting for visual clarity.
LibreOffice version: 25.8.3
OS: Windows 11 Pro 24H2
--
You are receiving this mail because:
You are the assignee for the bug.
