Issue 97254

Summary: Absolute $ references for conditional formatting not modified if referenced cell moves
Product: Calc Reporter: gleichmanna <mailgl>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P2 CC: cspalding3, issues, rainerbielefeld_ooo_qa
Version: OOo 3.0Keywords: oooqa
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Insert Columns\Rows With Conditional Formatting none

Description gleichmanna 2008-12-15 00:44:37 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'.
Comment 1 Rainer Bielefeld 2008-12-15 10:17:10 UTC 
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?
Comment 2 gregmcc 2010-04-30 22:54:57 UTC 
Created attachment 69213 [details]
Insert Columns\Rows With Conditional Formatting
Comment 3 gregmcc 2010-04-30 22:57:52 UTC 
Insert Rows / Columns when Conditional Formatting is being used -  generates 
errors - best described with the attachment 

InsertColumnsRowsWithConditionalFormatting.ods
Comment 4 Chuck Spalding 2013-08-09 21:42:15 UTC 
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.