To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98457 Issue #|98457 Summary|Filter on NULL / NOT NULL does not work on Spreadsheet | data sources Component|Database access Version|OOo 3.0.1 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|andreschnabel
------- Additional comments from andreschna...@openoffice.org Sun Jan 25 15:38:34 +0000 2009 ------- Given a spreadsheet data source which has some empty values in a column. If a filter is on NULL/NOT NULL is used for this colmun, either all or no row will be displayed. The test for "NULL" seems always to evaluate to true. Use attached example, create da data source from it and apply a NULL/NOT NULLfilter to the columns E-Mail or Eingeladen. --------------------------------------------------------------------- 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
