Apache OpenOffice (AOO) Bugzilla – Issue 21357
conditional formatting doesn't work when auto recalc is off
Last modified: 2017-05-20 11:13:28 UTC
conditional formats fail to work properly when automatic re-calculation is switched off. Worse than not working at all some formats are applied to fields in a seemlingly random way. Manual re-calc (f9) brings back some of the conditional formats with no inappropriate display but doesn't handle all applicable conditional formats correctly. Scenario: 20k+ line spreadsheet (4MB). One data column has conditional formatting applied to display orange background colour where flag in reference column (set either TRUE/FALSE) is TRUE. This conditional format failed to work at all after re-loading spreadsheet file or after manual re-calculation. Another column has two conditional format conditions applied to each cell. The first applies background colour red if reference column value is TRUE (value either 1 or 0). The second applies background colour green if cell value is greater than a reference threshold. The first condition never works at all unless automatic recalculation is on. The second condition is applied in a fairly random manner when file is loaded with no automatic recalculation i.e. the format *is* applied to some cells, some cells match the criteria others do not. F9 results in correctly applying the conditional formats but only for the second condition (correctly does *not* apply the second format when the first condition is met - but doesn't apply correct format for first condition). On loading file with auto recalc OFF the cells with incorrectly applied formats flicker continuously down to a row where beyond which there is no more flickering (approx 250 rows affected). Flickering does not disappear even after extended wait. Formula references were made completely relative. Incidentally, Shift-F4 working on these references would be a useful enhancement (not a big deal though - although remapping the reference afer column insertion would be a more useful enhancement still - column insertion breaks conditional formats). Switching automatic recalculation on makes everything work properly (apart from comments about enhancements above - don't have time to submit more than one issue).
Hi, please attach the / a document showing this behaviour. For now I can't reproduce what you're facing. Frank
Created attachment 10772 [details] spreadsheet exhibiting bug
Hi Niklas, as discussed, this one is yours. Frank
Conditional formats contain formulas, so their recalculation is disabled together with that of cells. I'm not sure if that can be changed. In any case, the flickering is wrong and should be fixed for 2.0.
Not sure bug report has been understood. Pressing F9 (re-calc) does not display the correct formats according to the conditions defined. It should do.
Due to time problems this is re-targeted to OOo2.0
This issue was filed in 2003, and "Due to time problems this is re-targeted to OOo2.0"? Well it's 2006 and version 2.0.3 is coming out soon. What's up? The online help ("Conditional Formatting") does not even mention this!
added ufi as cc / inserted a warning to online help in issue 64910
The problem was also debated here: http://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=61391 where I diagnosed the problem as being auto-calc related. It would be really ince and obvious bug to get fixed in somming releases...
Reset assigne to the default "issues@openoffice.apache.org".