How do I check filter criteria on Standard filter

rowman · March 13, 2019, 1:23pm

I have a Standard filter on a spreadsheet, I can click inside the range to reset the filter, but I would like to see what filter criteria is actually being applied. When I bring up the standard filter dialogue I would have expected to see the active filter criteria pre-filled in the edit boxes, but it doesn’t. (I’m using version 4.2.8.2).

Is there a way to check what filter is being applied? (not an auto filter).

edit.

Here’s a screenshot. No triangles, filter is active (note missing rows), data->filter has reset enabled. If I select Standard Filter column C is pre-filled ok, but the value is not. So I wondered if there was a way I didn’t know of to view the filters being applied.

image description

anon73440385 · March 13, 2019, 1:38pm

Apologize if I do not get you right - but the actual filter criteria applied for a standard filter can be seen by clicking on the filter arrow button and then selecting “Standard Filter” - a filter dialog will show up showing the “Filter Criteria” being active (This dialog also allows for more detailed criteria).

Hope that helps.

rowman · March 13, 2019, 2:03pm

Thank you. I don’t see a triangle on the column, I guess it’s the old version I’m running. I’ll need to upgrade I think.

Lupp · March 13, 2019, 2:24pm

@anon73440385: Sorry. Trying with V6.2 I also don’t see a “filter arrow”. Are you talking of the menu path
>Data>More Filters or did you customize your LibO in a specific way?

anon73440385 · March 13, 2019, 2:29pm

Ok - may be a used incorrect wording. But if you define a filter on a range, the first row is taken as header and gets a drop down button to select filter rules, but as obviously I misunderstood the question.

rowman · March 13, 2019, 2:45pm

@Lupp I’ve added a screenshot, and yes, I think we are talking about the same thing, but my menu is data->filter

Lupp · March 13, 2019, 3:43pm

(As far as I can tell only the AutoFilter variant of using filters creates the dropdown )

There is a fundamental conflict concerning ranges when using filters that never was solved as far as I know:

If you create a standard filter with the option Keep filter criteria the settings will actually be saved for the exact range they were defined for. But if you later select the shown data after you applied the filter, the selection does not contain the rows filtered out, but is in fact a collection of multiple ranges. Not accounting for this, the software, trying to assign filter criteria to the selection fails. Strange enough, the standard filter reinstates the original range if you change any criterion. In terms of the API: the method collapseToCurrentRegion is correctly called in the second case, but not in the first one.

If you select all the sheet, choose Show for all rows, select the exact originally filtered range, and go to the standard filter again, the criteria and options are correctly shown. Useless to say that’s useless.

===Edit1 2019-03-13 16:53===
If it’s urgent I may be able to provide user code (in Basic) to show the settings of an applied standard filter.