Inserting new rows makes conditional formatting rules complicated
If conditional formatting is applied across spreadsheet, then Inserting a new row above screws up the conditional formatting rules. See screenshot. Previously I had 4 rules for D4:ZY585. I then inserted a new row above row 86, and I now have 8 rules. The conditional formatting applies to the region I want it to, but it is messy, and it gets more complicated if I were to insert another new row.
- % Done changed from 0 to 100
1. Bugs for libreoffice should be reported to TDF bugzilla, not here.
2. There was already a bug report on this, and was fixed some month ago: