https://bugs.documentfoundation.org/show_bug.cgi?id=87274
--- Comment #4 from Jonas Müller <[email protected]> --- I think that this feature is really important. I noticed that LibreOffice 5.0.1 easily destroys the set range for conditional formatting. Steps: 1. Create a new spreadsheet. 2. Highlight A1 to A5 and open the menu for conditional formatting. 3. Create a new condition for A1 to A5 by choosing something like "Cell is" "contains" and "done" and pick one of the templates. 4. Add a new condition and choose "Cell is" "contains" and "waiting". 5. Click on okay. As you can see you now have a clean A1 to A5 rule. 6. Now click okay and write done in A1. 8. Copy A1 to A2 and open the conditional formatting menu again. 8. As you can see now you have the ranges "A2" and in addition "A3:A5:A1". As a result the menu will get more and more entries the more you edit the file. It can get really difficult to maintain clean conditions. LibreOffice should not create a new condition if there is already an identical one affecting this cell. Imo it would be great if LibreOffice would NOT change the conditions AT ALL when using copy&insert because that is usually and unwanted. So if you were to copy the word done from A1 to B2 it should not create a new condition for B2. But that's just my opinion. -- 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
