Issue 97254 - Absolute $ references for conditional formatting not modified if referenced cell moves
Summary: Absolute $ references for conditional formatting not modified if referenced c...
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.0
Hardware: PC Windows XP
: P2 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2008-12-15 00:44 UTC by gleichmanna
Modified: 2013-08-09 21:42 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Insert Columns\Rows With Conditional Formatting (10.43 KB, text/plain)
2010-04-30 22:54 UTC, gregmcc
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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 


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.