https://bugs.documentfoundation.org/show_bug.cgi?id=172044
Bug ID: 172044
Summary: Foreground color created with UNO is not saved in xlsx
file.
Product: LibreOffice
Version: 26.2.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
We recently discovered a weird problem in calc and it's ecosystem.
Symptom: foreground color is not saved in xlsx file.
The problem involve a combination of LibreOfficasCalc, PyUNO and xlsx files.
A demonstrator program and xlsx file are attached. See problem duplication
procedure below.
Steps to Reproduce:
1.Put the 2 attached files in any user-writable directory and cd to it. The
Python program requires UNO module.
2.Execute the python script with "python3 demo_program.py". The demo is
self-documenting.
3.At end of execution, the spreadsheet with colored cells is saved in xlsx
format and that file is opened for comparison purposes. You should notice that
the color of cells A1 and B2 are different.
Actual Results:
The foreground color of cells that had no color defined in the original file
will not be saved to the output file.
Expected Results:
Cells A1 and B2 should be colored in output file.
Reproducible: Always
User Profile Reset: No
Additional Info:
After many tests, we conclude that cells where color are not saved:
- are those that use 'default' color in the initial file.
- are those where UNO was used to set the 'CharColor' property.
The problem only happen when:
- input and output files are xlsx. xls files do not have the problem. The input
and output files may be the same (overwrite).
- the color change was done with UNO. Manual changes do not trigger the
problem.
It seems that only foreground color is affected. Other properties are not.
Problem exist on two different Debian13 machines.
--
You are receiving this mail because:
You are the assignee for the bug.
