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.
