Bug 95264 - Enhancement Suggestion: Save Filters as Favourites
Summary: Enhancement Suggestion: Save Filters as Favourites
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Data-Filter
  Show dependency treegraph
Reported: 2015-10-23 03:16 UTC by Daamon
Modified: 2019-01-04 18:59 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:

Sample file, advanced filter. (20.60 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-10-24 00:16 UTC, m.a.riosv

Note You need to log in before you can comment on or make changes to this bug.
Description Daamon 2015-10-23 03:16:59 UTC
Scenario 1: More than one Data Filter is commonly used on a data set - switching individual column filters is cumbersome and prone to error.

Scenario 2: You're in the middle of building or using a filter and you need to clear it to look at something else on the same data set before going back and having to start again.

The option to save the current Data Filter settings (the filters set per column) as a favourite for reuse later would be very handy.

Comment 1 Joel Madero 2015-10-23 14:51:59 UTC
Sounds reasonable.

FYI: Enhancements are almost entirely tackled by volunteers thus we give no ETA as to when (or even if) the enhancement will ever be implemented. This is just confirming that it's a valid request - not saying that it will ever be actually put into the project.

Thanks for the suggestion.
Comment 2 m.a.riosv 2015-10-24 00:16:42 UTC
Created attachment 119915 [details]
Sample file, advanced filter.

I think it can be done with Menu/Data/Sort/Advanced filter.

With it you can put the filters in cells, giving them a Name range (specified in Range Options type filter), then you can select it in the Advanced filter box.

Complex filter can be done in this way, once learned a bit about them (click the help button). With the advantage that you can see all conditions at once.

Create the data range in Menu/Data/Define range
Go to at any cell in data range or Menu/Data/Select range.
Menu/Data/Filter/Advanced filter, select the filter named range where it is '-undefined-'
Select in options if one is needed, Regular expressions is needed is they are used in defined filters.
Modified the applied filter and Menu/Data refresh to update with the new conditions.

Attached a sample file with two defined filters that have range Name.

Conditions on the same row works like an AND.
adding rows is row1-conditions OR row2-conditions etc.

Finally, adding a button in the toolbar or a shortcut to call Advanced filter, helps a lot.
Comment 3 Steve Magruder 2018-11-28 14:53:16 UTC
I could use this feature.

I have a program that generates a dataset that I export by way of CSV to Calc.  In my processing of this data, I enter a standard filter with two ANDs and an OR.  It feels tedious.  It would be great if I could just save this somewhere for reuse.
Comment 5 Steve Magruder 2018-12-29 17:08:57 UTC
Comment #2 doesn't address my scenario as I would have to create the filters in cells on every export.
Comment 6 m.a.riosv 2019-01-04 18:59:47 UTC
(In reply to Steve Magruder from comment #5)
> Comment #2 doesn't address my scenario as I would have to create the filters
> in cells on every export.

As explained in comment#2, you can have several pre-filters on different ranges and assigning to everyone of them a name range, then in the Advanced filter you can select the named range with the filter you like.
Adding an Icon for the advanced filter in a toolbar, make it really speed to work.