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.
I just tested this and it doesn't work. Attached is a simple document that show that it isn't working.
Created attachment 113135 [details] Demonstration that Missing Is Not Working
(In reply to Joel Madero from comment #13) > I just tested this and it doesn't work. Attached is a simple document that > show that it isn't working. Joel, It works if you *select* the entire data and then click autofilter. https://help.libreoffice.org/Calc/AutoFilter Please let me know if the patch still does not work for you. -- Deena
Created attachment 113162 [details] Sample spreadsheet with two Autofilter columns with some empty cells
(In reply to Deena P.F. from comment #15) > It works if you *select* the entire data and then click autofilter. > https://help.libreoffice.org/Calc/AutoFilter > > Please let me know if the patch still does not work for you. Deena, you are not supposed to need to select data. Joel's example wasn't very conclusive (I have attached a modified version) The problem here is that since Empty is not an item from the multi-item List, if you select Empty, you can not select another value (i.e. you can only get Control=a AND Test=Empty OR Control=a AND Test=2). The request is that you might filter cells that are Control=a AND Test=Empty AND Control=a AND Test=2 Hope this clarifies the request.
Created attachment 113165 [details] screenshot of adding filter on Column = Test
Created attachment 113166 [details] Screenshot of result of the filter applied Control=a Test=Empty Test=2
So weird - now it works fine. Anyways. Thanks for the patch. Closing this one as FIXED.
(In reply to Pedro from comment #17) > (In reply to Deena P.F. from comment #15) > > > It works if you *select* the entire data and then click autofilter. > > https://help.libreoffice.org/Calc/AutoFilter > > > > Please let me know if the patch still does not work for you. > > Deena, you are not supposed to need to select data. Joel's example wasn't > very conclusive (I have attached a modified version) > > The problem here is that since Empty is not an item from the multi-item > List, if you select Empty, you can not select another value (i.e. you can > only get Control=a AND Test=Empty OR Control=a AND Test=2). The request is > that you might filter cells that are Control=a AND Test=Empty AND Control=a > AND Test=2 > > Hope this clarifies the request. I am able to select Control=a, Test=Blank, Test=2 correctly with patch applied on master HEAD=5a94bc910aa4418326aef894fc412ab71b24bd31 Attached screenshots showing this. I will test with the latest master soon.
(In reply to Deena P.F. from comment #21) > I am able to select Control=a, Test=Blank, Test=2 correctly with patch > applied on master HEAD=5a94bc910aa4418326aef894fc412ab71b24bd31 > Attached screenshots showing this. I will test with the latest master soon. I assumed (wrongly) that it would be included in 4.4.0.3 since your patch was released well before 4.4.0 RC3. My bad for expecting this to be included in branch 4.4 In any case, now that you added Blank, it makes no sense to keep Empty and Not Empty in the filter drop menu. Should I open another Bug for this issue? In any case, Thank You! for fixing this annoying bug :)
(In reply to Pedro from comment #22) > (In reply to Deena P.F. from comment #21) > > > I am able to select Control=a, Test=Blank, Test=2 correctly with patch > > applied on master HEAD=5a94bc910aa4418326aef894fc412ab71b24bd31 > > Attached screenshots showing this. I will test with the latest master soon. > > I assumed (wrongly) that it would be included in 4.4.0.3 since your patch > was released well before 4.4.0 RC3. My bad for expecting this to be included > in branch 4.4 Unfortunately the patch in gerrit is not yet reviewed/merged and I am a beginner so I don't have commit access. > > In any case, now that you added Blank, it makes no sense to keep Empty and > Not Empty in the filter drop menu. > > Should I open another Bug for this issue? I think another bug report would be nice as it will bring fresh attention and comments/opinions.
The Blank option does not show up under Version: 4.5.0.0.alpha0+ Build ID: 6e1d28efb3d314d553e970f197f19636ce4e0ded TinderBox: Win-x86@39, Branch:master, Time: 2015-02-05_07:26:02 Locale: pt_PT running on Windows XP Pro x86 SP3
(In reply to Pedro from comment #24) > The Blank option does not show up under > > Version: 4.5.0.0.alpha0+ > Build ID: 6e1d28efb3d314d553e970f197f19636ce4e0ded > TinderBox: Win-x86@39, Branch:master, Time: 2015-02-05_07:26:02 > Locale: pt_PT > > running on Windows XP Pro x86 SP3 This is because the patch is not yet merged to master.
why is this marked FIXED? the patch is not merged at all.
I see an option for "empty" in my master built last night - I assumed that meant it was resolved.
Ideally when you add a filter - you wouldn't have to manually select the entire column. Instead the filter would automatically check to see what the last row that contains a value is, and then include everything from the filter to that cell. If you look in my test document you can see the issue. I suppose this should be another enhancement request. @Deena - any interest in being cc'ed on that one ?
(In reply to Joel Madero from comment #28) > Ideally when you add a filter - you wouldn't have to manually select the > entire column. Instead the filter would automatically check to see what the > last row that contains a value is, and then include everything from the > filter to that cell. > > If you look in my test document you can see the issue. I suppose this should > be another enhancement request. > > @Deena - any interest in being cc'ed on that one ? I didn't realize it wasn't accepted yet. It was marked as FIXED and you (Joel) confirmed it worked so I assumed it was already in Master (and therefore Comment #24). As a consequence I jumped ahead and submitted Bug #89158 (and took the liberty of CCing Deena) I really hope this moves forward because this is really an important missing feature for anyone that uses Autofilter.
Pushed to master https://gerrit.libreoffice.org/gitweb?p=core.git;a=commit;h=726430db96434f64037af719ad649ab109add5d1
there is something 'funny' with that checkbox, see https://bugs.documentfoundation.org/show_bug.cgi?id=68113#c8