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
*** This bug has been marked as a duplicate of bug 103368 ***
*** This bug has been marked as a duplicate of bug 104026 ***