Summary: | Enhancement Suggestion: Save Filters as Favourites | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Daamon <daamonp> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | jmadero.dev, miguelangelrv |
Priority: | medium | ||
Version: | 5.0.0.5 release | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 109326 | ||
Attachments: | Sample file, advanced filter. |
Description
Daamon
2015-10-23 03:16: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. 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. |