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
PS: I can reproduce this issue both on Windows and OSX
still present in 4.0.2 rc
*** This bug has been marked as a duplicate of bug 60215 ***