[Libreoffice-ux-advise] [Bug 124093] EDITING Selecting filtered cells with hidden rows in between causes a bug in filter reset.

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu Jul 6 15:55:53 UTC 2023


https://bugs.documentfoundation.org/show_bug.cgi?id=124093

--- Comment #18 from ady <adylo811517 at gmail.com> ---
(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 on the CC list for the bug.


More information about the Libreoffice-ux-advise mailing list