Bug 103367 - FORMATTING: Conditional Formatting dependent on neighbor cell breaks upon deleting line
Summary: FORMATTING: Conditional Formatting dependent on neighbor cell breaks upon del...
Status: RESOLVED DUPLICATE of bug 104026
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-10-20 21:30 UTC by Ralf
Modified: 2017-10-28 18:25 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Ralf 2016-10-20 21:30:52 UTC
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
Comment 1 m_a_riosv 2016-10-20 21:44:37 UTC

*** This bug has been marked as a duplicate of bug 103368 ***
Comment 2 Xisco Faulí 2017-10-28 18:25:04 UTC

*** This bug has been marked as a duplicate of bug 104026 ***