Bug 39571 - FORMATTING: Cell formatting with colors not working in Calc
Summary: FORMATTING: Cell formatting with colors not working in Calc
Status: CLOSED DUPLICATE of bug 37658
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.4.1 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
Whiteboard: numberformat
Depends on:
Reported: 2011-07-26 13:06 UTC by Andreas Hüller
Modified: 2012-02-16 07:32 UTC (History)
0 users

See Also:
Crash report or crash signature:

A1 and B2 should be 'RED' (15.63 KB, application/octet-stream)
2011-07-28 10:59 UTC, noname

Note You need to log in before you can comment on or make changes to this bug.
Description Andreas Hüller 2011-07-26 13:06:17 UTC
"Complex" cell formats containing color information without an minus sign in front of definition of negative part (e.g. [RED]0.00 for negative amounts) are lost when storing the document in XLS (Excel 2003) format in LibO 3.4.1.

Downgrading to v3.3.3 release solved the issue for me (although I had to restore the correct formatting manually) so I think this bug got introduced in the 3.4 branch.


1) Open LibO Calc (emtpy file)
2) Enter a random negative integer or decimal in a random cell
3) Right-click this cell an choose "Format Cells..."
4) Define a "complex" format containing a color information,
   e.g. 0.00" $";[RED]0.00" $" (formatting looks OK)
5) Save & re-open document in XLS format (Excel 2003)
6) Color of cell formatting is lost (while an optional "unit" - e.g. "$" - is preserved)
Comment 1 Markus Mohrhard 2011-07-26 16:39:30 UTC
might be related to bug 38956
Comment 2 noname 2011-07-28 10:58:45 UTC
Confirmed with [Win2K LibreOffice 3.4.2 OOO340m1 (Build:202)]

(In reply to comment #1)
> might be related to bug 38956

Not quite. That bugreport was about the numbers that wouldn't go red when pressing OK.
This is a saving problem.
When going to 'format cells' and clicking 'negative numbers red' and ok, when reloading a saved xls, xml and xslx file, 'negative numbers red' is always off.

When saving to uos (unified office format) this option is in some cells on and in some cells off, see attached file. Both A1 and B2 should be 'red'.
Comment 3 noname 2011-07-28 10:59:49 UTC
Created attachment 49680 [details]
A1 and B2 should be 'RED'
Comment 4 vitriol 2011-07-28 11:26:39 UTC
Maybe related to Bug 37658. It's a very bad regression and also affect the ODF format.
Comment 5 vitriol 2011-07-28 11:29:58 UTC
I mark this issue as a duplicate for now.

*** This bug has been marked as a duplicate of bug 37658 ***