https://bugs.documentfoundation.org/show_bug.cgi?id=167587
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED Resolution|--- |NOTABUG --- Comment #4 from ady <[email protected]> --- Colin, you are not new to TDF's Bugzilla. You already know that you should not present several different issues in one ticket, mixing procedures, over-complicated unclear steps... Anyway... Regarding the filtering issues, the filters in AutoFilter are separate from the Standard Filter. You use either of them. So, if you want to mix them, then the conditions need to be placed in the SF, as already explained in comment 2. As for deleting cell E7, the cell is part of your initial conditional format. As with any formula, when you delete a cell (i.e. the cell itself, not just its content), dependent cells will turn to a #REF! error. Finally, regarding the multiple UNDO / REDO behavior, these actions are not perfect in every situation, especially involving #REF! errors. This ticket is not a good sample in order to try to improve UNDO actions. There are more than enough of those tickets, and users tend to (incorrectly) expect every UNDO action to perfectly solve every (screw-up) action; that’s an over-expectation in Calc. I am closing this ticket as NAB. Please next time try a forum such as <https://ask.libreoffice.org>. -- You are receiving this mail because: You are the assignee for the bug.
