# How do I check filter criteria on Standard filter

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.

edit retag close merge delete

Sort by » oldest newest most voted

(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.

more

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.

more

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.

( 2019-03-13 15:03:07 +0100 )edit

@Opaque: 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?

( 2019-03-13 15:24:12 +0100 )edit

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.

( 2019-03-13 15:29:05 +0100 )edit

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

( 2019-03-13 15:45:10 +0100 )edit