Apache OpenOffice (AOO) Bugzilla – Issue 97254
Absolute $ references for conditional formatting not modified if referenced cell moves
Last modified: 2013-08-09 21:42:15 UTC
The conditional format value with a '$' in the reference is not updated if a row or column is inserted before the cell. to reproduce the bug: - new spreadsheet - fill A1 with 1, B1 with 1 - add conditional format to A1: cell value equal '$B$1' and set the template to e.g. title to see changes - now A1 is displayed bold - insert new row on row 1 - now the cell A2 is displayed not in the right condition format, should be displayed bold - the condition format is still '$B$1' and not '$B$2' as expected The same scenario with '$B1' as the conditional format value on the cell A1 works correct. After the row insert the condition format value change to '$B2'.
I checked with "Ooo 3.0.0 (DE) Multilingual version German UI WIN XP: [OOO300m9 (Build9358)]" and can confirm the reported effect. Bug or feature? I can't decide. I believe that behaviour for "$-references" (Example: "$F$5")should be: If a cell with $-reference-formula moves to an other place, the reverence should stay ("$F$5") If a referenced cell moves (here: 'F5' moves to 'G6' because a line and a row have been inserted), all references "$F$5" should be modified to "$G$6". In 1.1.4 I saw that expected behaviour, but no longer in 2.4 At least we have some inconsistence, as you see in my attached "sample.ods": Open "sample.ods" and insert a new line before old line 1, all $-references in column 'E' will be modified from "Line 1" to "Line 1", but formatting reference in A1 will not be modified. Conclusion in last sentence of report is wrong. Dup of Issue 4155?
Created attachment 69213 [details] Insert Columns\Rows With Conditional Formatting
Insert Rows / Columns when Conditional Formatting is being used - generates errors - best described with the attachment InsertColumnsRowsWithConditionalFormatting.ods
This bug also occurs if the referenced cell is on a different sheet in the current file (e.g., "'Sheet2'.B6>0). If the cell with the conditional formatting contains a formula (e.g., "=IF('Sheet2'.B6>0;123;321)"), that formula is modified when the referenced cell moves, but the cell reference in the conditional formatting is not modified.