When copying a row with conditional formatting, a new rule is created. If you use a row as a template, which is common practice, you wind up with thousands of rules. If LO Calc could be "smart" and combine rules when appropriate that would be useful.
Ah..it's been discussed few moments ago. Please reopen if you don't agree, and provide more explanation about your purpose.
*** This bug has been marked as a duplicate of bug 80768 ***
(In reply to comment #1)
> Ah..it's been discussed few moments ago. Please reopen if you don't agree,
> and provide more explanation about your purpose.
> *** This bug has been marked as a duplicate of bug 80768 ***
Thanks for finding that. From what I can tell it is a different bug.
1) It happens on not just extended selection but using cut and paste as well.
2) The result is that the conditional formatting gets a new rule for each row.
I'll try to explain #2 a little more because it warrants a better explanation.
If you have rows 1-10, with column E having conditional formatting. The rule is set up for E1:E10. Nice and clean.
Now you copy rows 4-5 and insert the copies into rows 7-8. Now you have Rows 1-12 in total.
Instead of LO Calc extending the conditional formatting rule to E1:E12, it will create multiple rules.
After doing this hundreds (or thousands of time), many features of LO Calc will start to fail, especially Sort.
I agree, the current process is wrong, fragmentation shouldn't occur.
I commonly use ranges that start at row 2 and extend 'forever' or at least until row 1048576 :)
I want those rules to apply for the entire range regardless of what I paste, whether or not I insert new rows or columns. And yes, the columns may need to be changed depending on where I insert a new column, but without fragmentation.
Having complained about this before, I received an explanation which wasn't really satisfactory but it works:
Insert a row, the CF rules haven't been fragmented.
Copy an existing row
Paste Special with the Formats option unticked (this is the one that screws things up).
and lo and behold, the CF rules haven't been fragmented.
If you make a mistake and click Paste, the rules become fragmented.
If you press Undo once to revert the Paste the rules remain fragmented.
If you press Undo again to delete the row, the rules are no longer fragmented.
Truly, the process to Paste into a range containing CF should not fragment the rules and leave it to the user to create new rules for the new row if that's appropriate (but it likely never going to happen).
If you have a range that's less than infinite and you insert a row (or column) into the middle, then the range should be extended.
Looks like same root with Bug 80768. But..I'm not a dev so I can't answer that :)
Let status UNCONFIRMED, waiting for experts to review this enhancement request
So - it seems like 4.3 might include this! Can you check it and confirm?
On the bottom you'll see 4.3.0 under pre-release.
Setting as WFM at least for now. If you can try with 4.3.0 and see if it also works for you and then mark as Verified -> WFM. if you can still confirm the issue please set back to UNCONFIRMED and I'll try again.
1. New Spreadsheet
2. Select E1:E10
3. Click Format -> Conditional Formatting -> Condition
4. Set Cell Value Is Equal To 10, apply style "Result"
5. Select Row5 and Row6
6. Right click and copy the rows
7. Select Rows 7 & 8
8. Right Click -> Insert Rows Above
Result: One clean rule "E1:E12 Cell Value is = 0"