Ask Your Question

How do I check filter criteria on Standard filter

asked 2019-03-13 14:23:26 +0100

rowman gravatar image

updated 2019-03-13 15:38:35 +0100

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

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


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

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-03-13 16:43:05 +0100

Lupp gravatar image

updated 2019-03-13 16:53:31 +0100

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

edit flag offensive delete link more

answered 2019-03-13 14:38:59 +0100

Opaque gravatar image

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.

edit flag offensive delete link 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.

rowman gravatar imagerowman ( 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?

Lupp gravatar imageLupp ( 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.

Opaque gravatar imageOpaque ( 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

rowman gravatar imagerowman ( 2019-03-13 15:45:10 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-03-13 14:23:26 +0100

Seen: 71 times

Last updated: Mar 13