Bug 78259

Summary: Enhancement request: make -Empty- one of the items for multiple choice in Autofilter
Product: LibreOffice Reporter: Pedro <pedlino>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE QA Contact:
Severity: enhancement    
Priority: medium CC: jerome.bouat, mariosv, suokunlong
Version: unspecified   
Hardware: Other   
OS: All   
See Also: https://bugs.freedesktop.org/show_bug.cgi?id=65505
Whiteboard:
i915 platform: i915 features:
Attachments: ODS spreadsheet with 3 Autofiltered columns

Description Pedro 2014-05-04 16:05:04 UTC 
Currently (since branch 3.5) you can select multiple items from the Autofilter dialog. However since Empty is a separate choice on the Autofilter menu, it is impossible to filter data based on a criteria such as (col1 = x OR col1 = empty) or a more complex filter such as (col1 = x OR col1 = empty) AND (col2 = y OR col2 = empty)

This could be simply solved by adding the -Empty- option to the multiple selection dialog (as it is possible in Excel 2007 and newer) instead of (or in addition to) one of the menu items.
Comment 1 Pedro 2014-05-04 16:09:55 UTC 
Created attachment 98419 [details]
ODS spreadsheet with 3 Autofiltered columns

Please see discussion about this issue in the comments of my answer to
http://ask.libreoffice.org/en/question/26829/autofilter-usage/

The attached file allows to quickly test the case proposed by user jnnewton
Comment 2 Jérôme 2014-07-07 20:28:04 UTC 
This duplicate bug describes a solution which would be intuitive for the end user, especially those using Microsoft Excel.

*** This bug has been marked as a duplicate of bug 44895 ***
Comment 3 Kevin Suo 2014-11-10 06:47:23 UTC 

*** This bug has been marked as a duplicate of bug 65505 ***

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.