https://bugs.documentfoundation.org/show_bug.cgi?id=167587
--- Comment #5 from Colin <[email protected]> --- (In reply to ady from comment #4) > 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... > I was unsure whether the formatting and deletion were the same issue or two "related" issues and I tried to provide examples and test data (together with the calculation results of the features) in the hope it would help trace the error. > 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. This is obviously highlighting one of the differences between Calc and Excel where the auto filter control provides for cumulative effects so the selection can be refined and permits superceding or supplementing by virtue of a simple tick-box. > 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. I have no idea how the conditional format ended up being controlled by the empty cells above the table - it was originally applied to the data contents of the table when the sheet was created. But I accept it's not behaving perfectly-that's why we have the bugzilla. > 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. Ady, That's unkind;), it was never a "screw-up". The working sheet I plagiarised was "extended" to allow the insertion of the additional analytical features of the table manipulation - to demonstrate to any tester how their potential playground metrics should react to any changes made. > I am closing this ticket as NAB. Please next time try a forum such as > <https://ask.libreoffice.org>. That's definitely your pay-grade -- You are receiving this mail because: You are the assignee for the bug.
