To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=73204
Issue #|73204
Summary|Auto filter: cannot filter for "non-blank cells only"
Component|Spreadsheet
Version|OOo 2.0.4
Platform|PC
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|editing
Assigned to|spreadsheet
Reported by|marcusmunich
------- Additional comments from [EMAIL PROTECTED] Sat Jan 6 09:33:52 -0800
2007 -------
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
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
