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. Thanks.
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.
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. Steps: 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. Ok. 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.
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.
Please see the sample on comment#2 https://help.libreoffice.org/6.1/en-US/text/scalc/guide/specialfilter.html?DbPAR=CALC#bm_id3148798
Comment #2 doesn't address my scenario as I would have to create the filters in cells on every export.
(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.