https://bugs.documentfoundation.org/show_bug.cgi?id=124093
--- Comment #9 from ady <[email protected]> --- (In reply to Julian Ragan from comment #8) > Apply filter and select rows 1:231 (and no further) as if for copying > filtered data to a separate location and reset the filter with selection > still on. You will notice, that rows 231 - 246 remain hidden. Not exactly, and this is the same as in comment 7: 1. Apply the filter as described in STR. 2. Select range 1:231 (both extremes are already shown, not hidden). 3. Reset filter. 1:231 are all shown, 232:245 remain hidden, as they were not selected and they were all hidden before step 2. Row 246 was not hidden before step 2, and remains not hidden after step 3. So, same behavior as in comment 7. > Another quirk - if user filters column A and selects 1:246 then reset filter > is greyed out. Again, as in comment 7: Menu Data > More Filters > Reset Filter is available only once, even if we then select a new different range that is still affected by some filter; this could/should be improved. > IMO Standard filter works on an entire columns when applied, so when reset > it should reset it completely. Not necessarily, because multiple standard Filters could be used/applied to multiple areas/columns. These are not necessarily simultaneously used, but they indeed affect the resulting hidden/displayed rows cumulatively. As I said, there is potential improvement, but resetting every-and-all filters while a specific range is already selected while resetting would be taking a feature away. As said in comment 7, to completely reset the filter you can use the "Clear" button within the Standard Filter dialog, whether the Reset Filter menu entry was already used or not. > But if a partial reset within selected range should be an option, It is already an available feature, whether unintentionally or not. It should remain a feature. I do agree that the menu entry should be improved, to be available more than once when adequate. > But if a partial reset within selected range should be an option, then it > should be shown in the context menu of the selected range of rows, also it > should check, if selected rows on one of the ends of selection are not next > to empty rows to avoid leaving last set of rows hidden after resetting the > filter within selected range. > > Also in menu Data -> More filters there should be an additional entry > "Remove filter" to remove it entirely. > > Current behavior is hard to notice on larger data sets for users that don't > expect it. Whatever changes are made, the fact that multiple non-simultaneous filters can be applied should always be considered. The effects are cumulative, but the filters are not all applied at the same time in one-and-only dialog. -- You are receiving this mail because: You are the assignee for the bug.
