Description: Table with conditional formatting used in at least one column: When deleting an entire line the next line's conditional formatting will be broken when it uses a reference to a neighbor cell. Steps to Reproduce: 1. Open example file CondFormatTest.ods (attached) 2. Select any cell in line 2 (e.g. B2) 3. Check the cell's conditional formatting ==> It's dependent on the formula IF(I2="Mediathek") [reference to neighbor cell] 4. Select menu Table => Delete Line ==> Line 2 disappears and lines 3, 4, and 5 are moved one up. 5. Check conditional formatting of cell H2 ==> It's expected to show the formula IF(I2="Mediathek") [reference to neighbor cell] ==> But it rather shows IF(I#REF!="Mediathek") [reference is broken] Actual Results: After moving the line 3 one up the reference to formerly I3 in conditional formatting breaks and is replaced with I#REF Expected Results: After moving the line 3 one up the reference to formerly I3 in conditional formatting is expected to be replaced with I2 Reproducible: Always User Profile Reset: No Additional Info: I don't think it's specific to version 5.2.2.2 because I observed that behavior with some previous versions, too (at least since major version 5). User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:49.0) Gecko/20100101 Firefox/49.0
Sorry, little error in reproduction steps: Step 2. should read: 2. Select cell H2
Created attachment 128109 [details] Example file
*** Bug 103367 has been marked as a duplicate of this bug. ***
Repro Version: 5.2.3.1 (x64) Build ID: 01ec8f357e651ca9656837b783cf7e6a32ee4d92 CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Locale: es-ES (es_ES); Calc: CL Version: 5.3.0.0.alpha0+ Build ID: c2b48a763df113e63e6a27ee05b9a6834e4e49a4 CPU Threads: 4; OS Version: Windows 6.2; UI Render: default; TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2016-10-20_06:56:44 Locale: es-ES (es_ES); Calc: CL
*** This bug has been marked as a duplicate of bug 104026 ***