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)
(earliest affected) Master
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
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:


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

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

  - 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

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,