Created attachment 55728 [details] File showing the bug Steps to Reproduce Open the attached file. It is not possible to select in column E only the entry containing "1". In 3.4.X this is possible.
Persists in 3.5RC3. A workaround is to use --empty-- and --not empty--. However, I consider this to be highly unintuitive.
Thanks for bugreport In 3.5.3 is also option "Standard filter...". It is very intuitive to click it.
Confirmed with: LO 3.5.5.3 Build ID: own W7 debug build Windows 7 Professional SP1 64 bit Selecting cell with "1" not possible. Workaround using Standard filter works fine.
May be author of this bugreport complains that impossible to enter needed value using keyboard? This problem exist and it is indeed unhandy.
If I may add my opinion, the standard filter workaround is not really satisfying. Indeed, this bug is an issue for me when I make several filters on several columns. It happens one contain only one content. If I want to unfilter some other columns while keeping only this value it is not possible. For example, the following thing is not possible in the example attached : 1-Filter on column b : no 2-Filter on column d : 1 3-Unfilter column b Since the standard filter "removes" the automatic filter, it is not really interesting to use in practice for such cases.
> Since the standard filter "removes" the automatic filter, it is not really > interesting to use in practice for such cases. Indeed, it is unhandy. Should be "empty" item in list of items. Possible workaround: add somewhere on bottom of table line with space in each cell. Cell with space will appear in Autofilter. And it may be used as "empty" item.
I think a better workaround is using the "Not Empty" filter, since it does not change the data...nonetheless, even after half a year, people in our office keep coming to me, wondering why it does not work...so, I insist "not intuitive"
Are we talking about normal autofilter or the autofilter with checkboxes? I believe the checkboxes ... Definitively a Bug. Not a regression, but bug in a new feature. Further research results soon!
Created attachment 72915 [details] Simple Sample Steps how to reproduce with parallel installation of "LOdev 4.0.0.1 rc - GERMAN UI / German Locale [Build ID: 527dba6f6e0cfbbc71bd6e7b88a52699bb48799)]" {tinderbox: @6, pull time 2013-01-10(?)} on German WIN7 Home Premium (64bit) with separate /40 User Profile for Master Branch: 1. open attached simple sample 2. Click Autofilter Button in A1 > Selector appears 3. Make sue that checkbox for "1" is checked 4. <OK> Expected: all empty rows hidden Actual: nothing, filter does not work
Easy workaround by using the Standard Filter Item in selector, so not a big problem. @Spreadsheet Team Please set Status to ASSIGNED and add yourself to "Assigned To" if you accept this Bug or forward the Bug if it's not your turf (and remove others in team from CC). BTW, who is our current filter expert?
*** Bug 68872 has been marked as a duplicate of this bug. ***
This bug still occurs on 4.1.6.2 version (x86-64 Windows).
*** Bug 78259 has been marked as a duplicate of this bug. ***
(In reply to Nikos from comment #0) > It is not possible to select in column E only the entry containing "1" It is not possible because there is no "Empty" checkbox in the autofilter. I am marking this bug as a duplicate of bug 65505. This is a feature request, and bug 65505 is "clean", with simple steps to reproduce. Feel free to set this back to NEW if you don't agree. Thanks! *** This bug has been marked as a duplicate of bug 65505 ***
@Kevin: Generally one dups a newer bug against an older to not disturb original dates, etc. If the description in newer bug is better, just append it tot his bug.
This bug should NOT be dupped against a newer bug. If the bugs are indeed indentical the newer bug should be dup'ed