Issue 109171 - AutoFilter not showing "empty" or "non-empty"
Summary: AutoFilter not showing "empty" or "non-empty"
Status: CLOSED DUPLICATE of issue 35578
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO320m12
Hardware: Unknown Other OS
: P2 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-02-11 19:32 UTC by raestlin
Modified: 2010-03-14 11:21 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Calc AutoFilter missing "blanks" or "empty" option (63.05 KB, image/jpeg)
2010-02-11 19:35 UTC, raestlin 		no flags Details
Excel '03 showing "blanks" option in AutoFilter. (38.64 KB, image/jpeg)
2010-02-11 19:38 UTC, raestlin 		no flags Details
Excel '07 showing "blanks" option in AutoFilter. (58.83 KB, image/jpeg)
2010-02-11 19:38 UTC, raestlin 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description raestlin 2010-02-11 19:32:07 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
Comment 1 raestlin 2010-02-11 19:35:56 UTC 
Created attachment 67764 [details]
Calc AutoFilter missing "blanks" or "empty" option
Comment 2 raestlin 2010-02-11 19:38:17 UTC 
Created attachment 67765 [details]
Excel '03 showing "blanks" option in AutoFilter.
Comment 3 raestlin 2010-02-11 19:38:53 UTC 
Created attachment 67766 [details]
Excel '07 showing "blanks" option in AutoFilter.
Comment 4 kyoshida 2010-02-11 19:44:12 UTC 
I think we already have a request for this... though I don't have the IZ number
at the moment.
Comment 5 Stefan Weigel 2010-03-14 11:21:07 UTC 
duplicate

*** This issue has been marked as a duplicate of 35578 ***
Comment 6 Stefan Weigel 2010-03-14 11:21:51 UTC 
closing