https://bugs.documentfoundation.org/show_bug.cgi?id=150637
Bug ID: 150637 Summary: Cut&pasting cells *within* a conditional formatting range, breaks the range; undo fails to restore Product: LibreOffice Version: 7.2.7.2 release Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: ddascalescu+freedesk...@gmail.com Created attachment 182049 --> https://bugs.documentfoundation.org/attachment.cgi?id=182049&action=edit Screencast I have a sheet with medical data spanning thousands of records (days). Each column is a conditional formatting range (percentile color scale). Say B3:B9 is a such a CF range. Cutting B8 and pasting it over B6 will break the range into B3:B5, B6, B7, B9. Also, formatting will be lost on B6. The narrated screencast illustrates this. I understand this might have been WAI per #57486, in order to not risk losing formatting, but, * in practice formatting is actually lost * undo is broken * it would be a *really* useful and semantically correct to keep the original range intact, as the user intention was. This would also nicely result in not losing formatting. In practice, with hundreds of rows and numerous edits, the CF ranges constantly become a broken mess, and I have to fix them to the original START:END points every other day. -- You are receiving this mail because: You are the assignee for the bug.