https://bugs.freedesktop.org/show_bug.cgi?id=61890
Priority: medium
Bug ID: 61890
Assignee: [email protected]
Summary: CONDITIONAL FORMATTING: formula in cond. form is wrong
after column insert
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.1.0.0.alpha0+ Master
Component: Spreadsheet
Product: LibreOffice
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
