Bug 61890 - CONDITIONAL FORMATTING: formula in cond. form is wrong after column insert
Summary: CONDITIONAL FORMATTING: formula in cond. form is wrong after column insert
Status: RESOLVED DUPLICATE of bug 59288
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.0.0.alpha0+ Master
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-03-06 09:07 UTC by oudeis69
Modified: 2013-03-06 11:36 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description oudeis69 2013-03-06 09:07:28 UTC 
Cell reference in conditional formula is not updated correctly after column 
insert. The cell reference has been updated *one* column too much (ie cell reference has been incremented twice)

How to reproduce:
  1. new ods
  2. in cell A1 add conditional formatting with FORMULA:
     "=B1 > 30" apply new style
  3. put value 40 in B1
  4. cell is formatted correctly

Problem:
  1. insert new column *BEFORE* column A
  2. formula is now "=D1 > 30" -- should be "=C1 > 30"

Notes: 
  - the error does not happen when inserting a column *AFTER* column A
  - a similar error happens when deleting columns
  - a similar error happens when inserting or deleting rows


Thanx!
Oudeis.
Comment 1 Jorendc 2013-03-06 11:34:58 UTC 

*** This bug has been marked as a duplicate of bug 59288 ***
Comment 2 Jorendc 2013-03-06 11:36:18 UTC 
Thanks for reporting!
I spoke to a core developer, and he pointed me this is already a known problem (see duplicate).

Kind regards,
Joren