Ask Your Question
0

Conditional format not working in 4 [closed]

asked 2013-04-09 12:34:36 +0200

kmashlea gravatar image

updated 2015-08-28 10:04:01 +0200

Alex Kemp gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-29 20:17:07.772906

4 Answers

Sort by » oldest newest most voted
1

answered 2013-04-12 02:34:59 +0200

horst gravatar image

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.

edit flag offensive delete link more

Comments

Thanks, that has sorted it.

kmashlea gravatar imagekmashlea ( 2013-04-12 20:13:14 +0200 )edit

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.

moggi gravatar imagemoggi ( 2013-04-12 23:43:44 +0200 )edit

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.

moggi gravatar imagemoggi ( 2013-04-12 23:43:50 +0200 )edit
1

answered 2013-04-09 13:30:58 +0200

JohnSUN gravatar image

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;@
edit flag offensive delete link more
0

answered 2013-04-09 16:23:38 +0200

m.a.riosv gravatar image

I think there are several bugs about it, for now you can use hard recalc (Shif+Ctrl+F9) to see the right format.

edit flag offensive delete link more

Comments

m.a.riosv gravatar imagem.a.riosv ( 2013-04-09 18:47:58 +0200 )edit
0

answered 2013-04-09 17:27:45 +0200

kmashlea gravatar image

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?

edit flag offensive delete link more

Comments

See fdo#60215 for it

moggi gravatar imagemoggi ( 2013-04-12 23:44:07 +0200 )edit

Question Tools

Stats

Asked: 2013-04-09 12:34:36 +0200

Seen: 1,028 times

Last updated: Apr 12 '13