| Summary: | CONDITIONAL FORMATTING: formula in cond. form is wrong after column insert | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | oudeis69 |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | jorendc |
| Priority: | medium | ||
| Version: | 4.1.0.0.alpha0+ Master | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Linux (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
*** This bug has been marked as a duplicate of bug 59288 *** Thanks for reporting! I spoke to a core developer, and he pointed me this is already a known problem (see duplicate). Kind regards, Joren |
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.