"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)
might be related to bug 38956
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'.
Created attachment 49680 [details] A1 and B2 should be 'RED'
Maybe related to Bug 37658. It's a very bad regression and also affect the ODF format.
I mark this issue as a duplicate for now. *** This bug has been marked as a duplicate of bug 37658 ***