Bug 61951 - Conditional color (styles?) not applied on document open
Summary: Conditional color (styles?) not applied on document open
Status: RESOLVED DUPLICATE of bug 60215
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) rc
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2013-03-07 09:22 UTC by Franky
Modified: 2013-11-19 19:01 UTC (History)
0 users

See Also:
Crash report or crash signature:

sample (26.67 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-03-07 09:22 UTC, Franky

Note You need to log in before you can comment on or make changes to this bug.
Description Franky 2013-03-07 09:22:10 UTC
Created attachment 76091 [details]

I have a simple spreadsheet to show me my investment development which involves solumns with total earnings out of the investments. I set the formatting for it to the red/black currency scheme (so I see easily when I lost money and when I made money).
This works when you enter new data but when you close the document and open it again everything is black. The only way to fix it is to change values that affect the earnings calculation.

I attached my document with sample values (not gonna give you my real data ;)). If you open it the "Earnings" and "Sum(Earnings)" will all be black, however if you change a value that affects the calculation (eg. "Money" or even the date) it will recalculate and apply the style correctly.

The issue first appeared in 4.0 and is still present in 4.0.1
Comment 1 Franky 2013-03-07 09:22:43 UTC
PS: I can reproduce this issue both on Windows and OSX
Comment 2 Franky 2013-03-15 16:40:54 UTC
still present in 4.0.2 rc
Comment 3 vitriol 2013-03-15 18:54:21 UTC

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