Created attachment 74431 [details]
Table of sunspot data. Columns D and E are formatted to have negative numbers in red.
In a book created by a previous version of Calc, I noticed that a column of numbers were all in black, whether or not they were negative. The formatting said they should be red if negative. I changed the formatting several times, lastly to scientific notation, but it appeared to have no effect. I then saved and closed the book.
On opening the saved version with LO 3.6.3, I found the formatting had taken effect, complete with scientific notation, although 4.0.0 hadn't displayed the change. Opening again with 4.0.0, the changed formatting still wasn't visible.
This problem doesn't occur with all numbers; it seems limited to calculated numbers and not directly entered ones. I will do more testing to try to see a pattern.
Hi Graham, thanks for reporting.
Version 220.127.116.11 (Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89)
If you do a hard calculate the cell looks right (Ctrl+Shift+F9).
Seems to be in relation with the new options in:
Menu/Tools/Options/LibreOffice Calc/Formula/Recalculation on file load/ODF Spreadsheet
setting the option to always recalculate show the format cell right.
I can confirm that it appears to only affect calculated fields.
Both suggestions made by mariosv do work.
My reservation with using the setting the options method is that 'recalculation on file load' implies that it recalculates all ODF spreadsheets (not saved in LibreOffice).
This is confusing as it was saved by LibreOffice, albeit an earlier version.
Also you may not want to recalculate ODF files from other sources?
It bothers me more that saving the file using 18.104.22.168 does not resolve the actual problem, as reloading the file takes you back to the original problem.
Pesonally I will just do a manual (Ctrl+Shift+F9) for now.
May I suggest looking at the code that reads the file in and makes the appropriate decision to recalculate or not.
Thanks to everyone.
I have the same experience. I think it is still a bug. Mariosv's solution is a workaround only.
This one is more or less a DUP of "Bug 60215 - FILEOPEN: Complete Currency FORMATTING VIEWING needs recalculation", but shows some additional effects might have become visible here. For details see my comments in Bug 60215
*** This bug has been marked as a duplicate of bug 60215 ***