Bug 39571

Summary: FORMATTING: Cell formatting with colors not working in Calc
Product: LibreOffice Reporter: Andreas Hüller <futuria2004>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: CLOSED DUPLICATE    
Severity: normal    
Priority: medium    
Version: 3.4.1 release   
Hardware: x86 (IA32)   
OS: Windows (All)   
Whiteboard: numberformat
Crash report or crash signature: Regression By:
Attachments: A1 and B2 should be 'RED'

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.


Reproduction:

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