https://bugs.documentfoundation.org/show_bug.cgi?id=124093
--- Comment #18 from ady <[email protected]> --- (In reply to Heiko Tietze from comment #17) > The filter cannot be applied to a selection, it always expands to the full > range. That's incorrect. Both the Standard Filter and the AutoFilter can be applied to a _selection_ that does not include every-and-all adjacent cells. Just select a range and try; for instance, leave the first cell of the range out of the selection before activating the (auto)filter. > We should do the same for Reset (and don't disable). That suggestion is a contradiction, and it goes against what I already explained in prior comments. Currently, the Reset acts on the _selection_; and when there is no specific selection, it acts on the filter that is relevant to the range that includes the active cell. My comments are still consistent with your screencast of comment 17; it just happens that you are not selecting any specific range/cell, and that the Reset menu entry acts only on 1 of the areas – I don’t know what’s the algorithm for it. If possible, "Reset" should be allowed to act multiple times (unless there is no filter left active to reset on any area), but should not expand automatically to the whole range when a specific range is selected; it should act on the selected range only. The "Clear" button acts on the whole affected area. There might be possible enhancements there too. -- You are receiving this mail because: You are the assignee for the bug.
