Just upgraded to to 4.0.2.2 from 3.6.5 and found that all the conditional formatting no longer works.
The main one I use is:
[RED]0.0;[BLUE]0.0
This went wrong in the past got fixed and appears to have failed again?
Is there a fix? or do I need to revert back to version 3?
You probably do not mean the Conditional Formatting, but Conditional Brackets?
First, make sure that you have not enabled Highlight values (Ctrl+F8 or View-Value Highlighting)
And try to use the full syntax for Conditional Brackets - Use all three numeric (for plus, for minus and for zero) and textual variants into the bargain
[RED]0.0;[BLUE]0.0;0.0;@You don’t have to file a bug report. In version 4 the devs somehow implemented a security feature to NOT recalculate a spresdsheet on loading ( Macros with virus!).
To fix it permanently open Calc and go to Tools->Libreoffice Calc ->Formula and change the change the 2 options under “Recalculation on file load” to “Always recalculate”. This way you don’t need to perform a hard recalculate after each loading.
Thanks, that has sorted it.
This is not a security feature. This improves the import performance of large files significantly but sadly contained this bug so we disabled the feature by default for the upcoming 4.0.3 as the fix needs a larger refactoring of the calc core.
This is not a security feature. This improves the import performance of large files significantly but sadly contained this bug so we disabled the feature by default for the upcoming 4.0.3 as the fix needs a larger refactoring of the calc core.
I think there are several bugs about it, for now you can use hard recalc (Shif+Ctrl+F9) to see the right format.
Thanks,
Using the three inputs does nothing.
Shift-Ctrl-F9 does re-show correctly but reverts on re load to not showing correctly.
Is there a bug report in about this or do I need to do something to raise one?
See fdo#60215 for it