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.
Created attachment 117260 [details] Graphical reproduction of the bug Here you can see how the rule is at the start, then after copy/pasting a cell within the same range and how it ends up all segmented.
Hi @Benjamin, thanks for reporting. It's how it works for nwo. At the end of 2014 I opended a request for enhancement about this matter. *** This bug has been marked as a duplicate of bug 87274 ***