https://bugs.documentfoundation.org/show_bug.cgi?id=92769
Bug ID: 92769
Summary: EDITING: Broken Conditional Formatting When Copying
Product: LibreOffice
Version: unspecified
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Let's say I have a set of cells from A1:Z100 that have the following
conditional formatting setting:
If cell A1:Z100 contains "N/A" then change color to RED.
And it works fine, however if I take a cell from inside the set e.g. A10 and
copy-paste its value into another cell within the same set e.g. (D10), Calc
would mess up the conditional formatting rules, creating a new rule for just
the copied cell and will break up the original rule, like so:
If cell D10 contains "N/A" then change color to RED.
If cell A1:Z9,A11:Z100,A10:C10,E10:Z10 contains "N/A" then change color to RED.
As you can see, it divides the set into the rows above, the rows below and then
the columns before and after on the same row. This is weird, since I'm not
introducing a new rule nor I am working out of the set. This is very annoying
since every little change will break up the whole formatting rule up to the
point where it has the exact same rule for every single cell in the set and I
have to delete them all and create a new one like the original:
If cell A1:Z100 contains "N/A" then change color to RED.
I can reproduce this everytime on LibreOffice Calc Version: 4.4.4.3,
compilation :4.4.4.3-3.fc22 the langpack es_MX.utf8.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
