Apache OpenOffice (AOO) Bugzilla – Issue 109171
AutoFilter not showing "empty" or "non-empty"
Last modified: 2010-03-14 11:21:51 UTC
In Excel, when you setup the Auto-Filter, you get the option to choose "empty" or "blanks". The AutoFilter in Calc only shows true data options. You have to use the "standard filter" to filter by "blanks" or "empty". Can you please add the "empty" or "blanks" option to the AutoFilter? ~ Chris
Created attachment 67764 [details] Calc AutoFilter missing "blanks" or "empty" option
Created attachment 67765 [details] Excel '03 showing "blanks" option in AutoFilter.
Created attachment 67766 [details] Excel '07 showing "blanks" option in AutoFilter.
I think we already have a request for this... though I don't have the IZ number at the moment.
duplicate *** This issue has been marked as a duplicate of 35578 ***
closing