Issue 73204 - Auto filter: cannot filter for "non-blank cells only"
Summary: Auto filter: cannot filter for "non-blank cells only"
Status: CLOSED DUPLICATE of issue 35579
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0.4
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Keywords: oooqa
Depends on:
Reported: 2007-01-06 17:33 UTC by marcusmunich
Modified: 2008-05-17 23:37 UTC (History)
1 user (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description marcusmunich 2007-01-06 17:33:52 UTC


Aaa	123	456
Aaa	124	457
Bbb	125	458
Aaa	126	459
Bbb	127	460
Aaa	133	466
Aaa	134	467
	135	468
	136	469
	137	470
	138	471
	139	472

(Example end)

by using the Standard filter in the auto filter drop down menu I have entered 
the following condition:

field(Aaa)   <>     " " 

(Tried it with " and without)and it did not work as wished.

Further explenation:
I have tried to filter to only show me the rows containing the Aaa or Bbb in 
the corresponding column (means only the non-blanks in this column 
[CELL<>" "] ), which unfortunately did not work.
By the way: Excel shows the option to show blanks and non-blanks in the drop 
down menu of the auto filter. Would be nice to have this functionality in oo as 

Thanks for your help,

Comment 1 kpalagin 2007-01-06 20:40:16 UTC
you do not need to type anything in "Value" in "Standard Filter" dialog. Then 
you will get non-blanks.

I am resolving your issue as duplicate of and suggest voting for 
issues 35579 and 69690.

*** This issue has been marked as a duplicate of 35579 ***
Comment 2 ace_dent 2008-05-17 21:33:50 UTC
The Issue you raised has been marked as 'Resolved' and not updated within the
last 1 year+. I am therefore setting this issue to 'Verified' as the first step
towards Closing it. If you feel this is incorrect, please re-open the issue and
add any comments.

Many thanks,
Cleaning-up and Closing old Issues
~ The Grand Bug Squash, pre v3 ~
Comment 3 ace_dent 2008-05-17 23:37:05 UTC
As per previous posting: Verified -> Closed.
A Closed Issue is a Happy Issue (TM).