https://bugs.documentfoundation.org/show_bug.cgi?id=124093
--- Comment #10 from Julian Ragan <[email protected]> --- (In reply to ady from comment #9) > (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. This behavior at the very least should be considered buggy, there is no way to select rows 232:246 and reset filter, also if you reset filter once, you cannot clear filter later to show rows that were hidden by filter and not shown by filter reset. It seems that reset filter command orphans filtered out rows as no longer filtered and sets them hidden. But this may be an effect of expecting Reset Filter to work in such a case like clear filter in filter dialog. > > 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. No, I mean user applies filter and selects more rows, than were affected by filter, then resetting filter is not available. But that may be a result of me confusing filter reset with clearing filter in filter dialog. > > IMO Standard filter works on an entire columns when applied, so when reset > > it should reset it completely. This was a feature misunderstanding on my part. Sorry. > 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. So it seems, but it leads to unexpected results for users without large experience in using filtering feature. Also reset filter command is easily confused with clear filter. Perhaps a more in depth look at current feature set is necessary. -- You are receiving this mail because: You are the assignee for the bug.
