Ask Your Question

Use a saved filter in Calc ?

asked 2015-08-23 11:09:27 +0200

ychaouche gravatar image

image description

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

image description

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-08-23 17:58:54 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-08-23 11:09:27 +0200

Seen: 1,169 times

Last updated: Aug 23 '15