Created attachment 182049 [details] 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.
Created attachment 182050 [details] Test case
CF it's part of the cell format, so when you cut the cell, you cut the content and the cell format including CF. Instead, you can copy first and the use delete-key to delete cell content.
Talking about undo, the current behaviour started with the same bibisect result I got for bug 129813 just now. The earlier behaviour was not correct either, though. *** This bug has been marked as a duplicate of bug 129813 ***