Issue 73204

Summary:	Auto filter: cannot filter for "non-blank cells only"
Product:	Calc	Reporter:	marcusmunich <donat_org>
Component:	editing	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 2.0.4	Keywords:	oooqa
Target Milestone:	---
Hardware:	PC
OS:	Windows XP
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description marcusmunich 2007-01-06 17:33:52 UTC

Hi,  

Example:

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 
well??

Thanks for your help,

Marcus

Comment 1 kpalagin 2007-01-06 20:40:16 UTC

marcusmunich,
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 
http://www.openoffice.org/issues/show_bug.cgi?id=35579 and suggest voting for 
issues 35579 and 69690.
Thanks.

*** 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,
Andrew
 
Cleaning-up and Closing old Issues
~ The Grand Bug Squash, pre v3 ~
http://marketing.openoffice.org/3.0/announcementbeta.html

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).

Regards,
Andrew