Issue 92628 - Cell References with $ in Conditional Formatting incorrectly updated when rows are inserted or deleted
Summary: Cell References with $ in Conditional Formatting incorrectly updated when row...
Status: CLOSED DUPLICATE of issue 4155
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.4.1
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: needhelp, oooqa
Depends on:
Blocks:
 
Reported: 2008-08-10 06:40 UTC by waynemv
Modified: 2008-08-10 20:52 UTC (History)
2 users (show)

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

Attachments
Example of conditional formatting bug involving $ (9.79 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-08-10 06:44 UTC, waynemv 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description waynemv 2008-08-10 06:40:42 UTC 
If new rows are added, or rows deleted, above a region of the spreadsheet
containing conditional formatting with dollar signs... the cell references in
the conditional formatting do not stay in sync with the new locations of the
cells they were intended to reference.

Let conditional formatting in cell B4 be "B$3<=$A4".  If row 1 of the
spreadsheet is deleted, cell B4 is now referenced as B3, and its conditional
formatting changes to "B$3<=$A3".  But it should change to "B$2<=$A3".  (The
dollar signs should not prevent any cell references from being updated in this
case.)
Comment 1 waynemv 2008-08-10 06:44:00 UTC 
Created attachment 55673 [details]
Example of conditional formatting bug involving $
Comment 2 Rainer Bielefeld 2008-08-10 10:34:10 UTC 
I checked with "Ooo-dev 3.0.0 Beta Multilingual version German UI WIN XP:
[300m29 (Build9339)]"  and can confirm the reported effect. Same with 1.1.4 and
3.0.0 beta (m29).

I agree, that is unexpected:

A cell reference "=$C$10" will be modified to "=$C$9" if row 1 will be deleted,
but the reference for conditional formatting will not be updated. Bug? Feature?
I can't decide that, but as mentioned, for me that is unexpected.
Comment 3 frank 2008-08-10 20:51:46 UTC 
double to Issue 4155

*** This issue has been marked as a duplicate of 4155 ***
Comment 4 frank 2008-08-10 20:52:07 UTC 
closed double