Use a saved filter in Calc?

[ychaouche]

I keep switching between this selection and full list. Clicking on individual checkboxes each time is a little annoying. I thought about saving the selection as a custom filter but couldn’t find anything under data

I’m also open to other solutions or workarounds, like for ex. having another sheet that automatically updates from this sheet and only gets the filtered rows.

[mariosv]

It’s possible to do it with advanced filter, it takes the filter from a cell range.

Search in the help for: Filter: Applying Advanced Filters to know how to use it.

But as consequence of a bug in version 5 the dialog box of the filter is transparent, making impossible to work with it.
Works well with previous versions.