https://bugs.documentfoundation.org/show_bug.cgi?id=124093
--- Comment #16 from ady <[email protected]> --- (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 the assignee for the bug.
