https://bugs.documentfoundation.org/show_bug.cgi?id=103367
Bug ID: 103367
Summary: FORMATTING: Conditional Formatting dependent on
neighbor cell breaks upon deleting line
Product: LibreOffice
Version: 5.2.2.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
