Problem description: Steps to reproduce: 1. from the menu, choose Data > Filter > Autofilter 2. when clicking on the auto-filter-dropdown, there is a list of checkboxes, which shows possible values of that column Current behavior: there is no checkbox representing empty cells Expected behavior: there should be a checkbox like [ ] (empty) This would enable the user to easily include empty cells among other values. Eg "Show me all entries which have the value 1 or empty." Known workaround: use the standard filter option Operating System: Ubuntu Version: 4.0.2.2 release
There are 'Empty' and 'Not Empty' options (without checkbox) above 'Standard Filter...' option. LO 4.0.4.1
I'm really sorry for not reading description carefully. > Expected behavior: > there should be a checkbox like > [ ] (empty) > This would enable the user to easily include empty cells among other values. > Eg "Show me all entries which have the value 1 or empty." At present that's not possible. So marking this as Enhancement request
Thank you very much :)
Looks like this was confirmed as an enhancement request. Moving to NEW.
*** Bug 82821 has been marked as a duplicate of this bug. ***
*** Bug 44895 has been marked as a duplicate of this bug. ***
*** Bug 68872 has been marked as a duplicate of this bug. ***
*** Bug 78259 has been marked as a duplicate of this bug. ***
(In reply to Kevin Suo from comment #6) > *** Bug 44895 has been marked as a duplicate of this bug. *** I think you should always mark the newer as duplicate. If the description, or the ewxamples are better in the new bug, copy them over to the older bug. If you don't adhere to this you'll screw up the bug resolution statistics, and probably the prioritization.
If all these issues are folded into one, Bug 68406 needs to be included as well. But whichever one it is, maybe its importance should be "normal" rather than "enhancement" - some aspects of the current behaviour are simply wrong.
(In reply to Rob from comment #9) Per this wiki: https://wiki.documentfoundation.org/QA/Bugzilla/FAQ#How_to_Mark_a_Bug_as_Duplicate It says: > Generally the latest report will be marked as a DUP of a more early report, except the new report contains more information or has a more advanced status (Assigned). I mark Bug 44895 as a duplicate of bug 65505, because bug 65505 "contains more information" in the main report section (clear steps to reproduce, current behaviour and expected behaviour), which is important for devs to understand. People don't have to read more than 10 comments in order to understand what's the issue here. The most importantly, bug 65505 is the root cause of bug 44895 (Autofilter can work with checkbox selection if column cells contain only one value and empty cells, *Only when* there is a "Empty" checkbox.)
Submitted a patch at https://gerrit.libreoffice.org/#/c/13573/. -- Deena Francis Affiliation : Libre Data Consultancy Services (P) Ltd.
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.