[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 09:25:28 UTC 2023


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

--- Comment #16 from ady <adylo811517 at gmail.com> ---
(In reply to Heiko Tietze from comment #15)
> Selecting the whole row does not enable Reset, neither selecting A1
> to the end (shift+ctrl+down) but A6.

You have not filtered any set of values at all, so there is no Reset available.

> We could simply solve the problem by extending the selection to the whole
> block as it happens for applying a filter - you cannot filter A1:A3
> separately from A4:A6 but need some empty cell between.

FWIW, I don't understand what you mean. The ranges you are mentioning here are
not clear to me.

At any rate, selecting menu Data > Autofilter once should add an autofilter.
Selecting the same menu entry a second time (whether having the list already
filtered or not) should clear the relevant filter (according to active cell)
and should also remove the autofilter down arrow. This is also useful when the
list does not include a header and the first item is filtered out (thus, the
autofilter down-arrow is hidden in such case).

-- 
You are receiving this mail because:
You are on the CC list for the bug.


More information about the Libreoffice-ux-advise mailing list