https://bugs.documentfoundation.org/show_bug.cgi?id=133112
--- Comment #20 from Thomas Maeder <[email protected]> --- Created attachment 200573 --> https://bugs.documentfoundation.org/attachment.cgi?id=200573&action=edit Conclusion / "range conservation" Version: 25.2.2.2 (X86_64) / LibreOffice Community Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac CPU threads: 8; OS: macOS 12.7.6; UI render: default; VCL: osx Locale: fr-CH (fr_CH.UTF-8); UI: fr-FR Calc: threaded This is the LO version for comments 10-19. As a parting shot: although Calc is in general excellent, conditional formatting is one of the least robust features, as it is easily corrupted / fragmented. As the CF guide says: https://wiki.documentfoundation.org/images/d/d1/LibreOffice_Calc._Conditional_formatting_guide_EN.pdf "Unfortunately, many users don’t use conditional formatting in their work." Sadly, one understands why, and I tend to underuse it myself because it is not very robust. In particular here: Undo should be "Undo", i.e. revert to the exact same state as before the command, which is here not the case. Especially common is the "CF range fragmentation issue", see e.g. https://bugs.documentfoundation.org/show_bug.cgi?id=153506#c27 (Here, $C$3:$D$1503 became $C$3:$D$55;$C$58:$D$94;$C$96:$D$1503 and then much worse.) As some sort of workaround, I always maintain near the CF ranges of my files a cell that calculates what the range should be (see A20 in this attachment), whose value I can paste into the CF range if it starts to become fragmented. -- You are receiving this mail because: You are the assignee for the bug.
