https://bugs.documentfoundation.org/show_bug.cgi?id=157618
Bug ID: 157618
Summary: FILESAVE: Calc ignores directly formatted text color
in .ods files
Product: LibreOffice
Version: 7.5.7.1 release
Hardware: All
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Android Editor
Assignee: [email protected]
Reporter: [email protected]
Description:
Saving to an .ods file appears to corrupt the directly formatted text in a
cell. Specifically, if a cell has a style with a dark background color (e.g.
red) and the cell is directly formatted with the following, the text will be
rendered as white even though the background of the cell is white:
- Text color for the cell is directly formatted to "automatic"
- Background color for the cell is directly formatted to "no fill"
Steps to Reproduce:
1. Open a new Calc spreadsheet
2. Select cell A1 and enter some text
3. Select the Styles > Error menu item. This well change the cell's background
color to red and the text color to white.
3. Using the Font Color toolbar button, set the text color to "Automatic" and
using the Background Color toolbar button, set the background color to "No
Fill".
This will change the cell's background color to transparent and the automatic
text color will render as black.
4. Save Calc spreadsheet as an .ods file and then immediately save as an .xlsx.
5. Close Calc spreadsheet.
Actual Results:
When the .ods file is opened, the cell is correctly rendered with a white
background but the text is incorrectly rendered as white instead of black.
When the .xlsx file is opened, the cell is correctly rendered with black text
on a white background.
Expected Results:
The cell in the .ods file should be rendered like the cell in the .xlsx file
with black text on a white background.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Not sure when this bug started occurring but it occurs as far back as
LibreOffice 7.5.7.1 but does not occur in OpenOffice 4.1.14 or NeoOffice 2022.7
(i.e. LibreOffice 4.4).
My first guess is that the bug occurs when saving and .ods file since the same
bug occurs when opening the .ods file in Microsoft Excel.
--
You are receiving this mail because:
You are the assignee for the bug.
