Issue 66885 - Conditional formatting relative links fail
Summary: Conditional formatting relative links fail
Status: CLOSED DUPLICATE of issue 4155
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.2
Hardware: PC Windows 98
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-06-30 10:30 UTC by drc
Modified: 2006-06-30 10:41 UTC (History)
1 user (show)

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

Attachments
Spreadsheet with conditional formatting (115.05 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-06-30 10:32 UTC, drc 		no flags Details
Spreadsheet with conditional formatting (115.05 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-06-30 10:32 UTC, drc 		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 drc 2006-06-30 10:30:32 UTC 
Column E of the spreadsheet attached has conditional formatting in the main 
body of the table (rows 7 to 174)   This indicates whether the value in E is 
greater or less than the corresponding value in column EU.

If I insert a new column between E and F the relative reference used for the 
comparison is not updated.

In general, calculation references survive the insertion of rows and columns, 
but conditional formatting references do not.   Ugh!
Comment 1 drc 2006-06-30 10:32:51 UTC 
Created attachment 37438 [details]
Spreadsheet with conditional formatting
Comment 2 drc 2006-06-30 10:32:59 UTC 
Created attachment 37439 [details]
Spreadsheet with conditional formatting
Comment 3 frank 2006-06-30 10:40:52 UTC 
double to Issue 4155

*** This issue has been marked as a duplicate of 4155 ***
Comment 4 frank 2006-06-30 10:41:10 UTC 
closed double