https://bugs.documentfoundation.org/show_bug.cgi?id=95264
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] | |rg --- Comment #2 from m.a.riosv <[email protected]> --- Created attachment 119915 --> https://bugs.documentfoundation.org/attachment.cgi?id=119915&action=edit 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. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
