Description: If I add values in some cells where I previously defined conditional formatting, and then I undo these operations, so that the cells can be empty again, the conditional formatting rules are affected by the undo feature, even if I added these rules a few days ago and, since then, I have opened and closed my document several times. Also, these changes to the conditional formatting don’t make sense. Steps to Reproduce: 1. I open a Calc document where I previously defined conditional formatting on some cells. 2. I change the values of the cells on the first empty row. 3. I undo these operations. Actual Results: The cells are empty again, as expected, but some conditional formatting rules get changed too: in particular, some rules are duplicated. Expected Results: The only change caused by the undo feature should be the cells getting empty, as it’s all I have done since I opened the document. Reproducible: Always User Profile Reset: Yes Additional Info: The undo feature should only affect operations that I have done in my current session. It shouldn't affect the rules for conditional formatting that I defined in the past. Actually, I think the undo feature shouldn't affect the conditional formatting rules at all, even if defined in the current session.
Created attachment 199268 [details] Conditional formating before undo
Created attachment 199269 [details] Conditional formatting after undo
Created attachment 199270 [details] Screen recording
Created attachment 199271 [details] Calc document The value for G5 must be added manually (and it must be equal to or higher than the value above), but the values for H5, I5 and J5 need to be calculated, so you need to drag from the cell above to copy the formula.
I’ve been thinking further about my issue and here are some additional thoughts: - Once I type a value for G5 and I drag down H4, I4 and J4 to extend the formulas to row 5, the conditions that I previously created for H2:H4, I2:I4 and J2:J4 are automatically extended to H5, I5 and J5. - Therefore, if I undo all these operations, which have indirectly affected the conditions, it makes sense for the undo feature to affect these conditions, so I was wrong when I thought that my conditions needed to rest unmodified after running undo. - However, the undo feature affects the conditions in a weird way: to be precise, conditions are split up into two. - My document, once I run the undo feature as many times as I can, should look exactly the same as it was before I opened it.