To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=53986 Issue #:|53986 Summary:|Advanced filter ignores not equal <> comparison Component:|Spreadsheet Version:|OOO 2.0 Beta2 Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|viewing Assigned to:|spreadsheet Reported by:|dalesc
------- Additional comments from [EMAIL PROTECTED] Tue Aug 30 07:53:30 -0700 2005 ------- Using advanced filter with a seperate filter criteria area which contains <> for a not equal match doesn't work. The not equal condition is ignored and matching continues IF there is more than one line of criteria. e.g. | status | programmer | tester | | <>"done" | PT | | | <>"done" | | PT | If used as a criteria for a filter, should find all rows where programmer or tester is "PT" but status is not "done". However the Status field is disregarded or has no effect. If you remove one line from the filter definition so only one remains then the status comparison works properly. Although, in the this case, obviously, we can only check the "programmer" OR "tester" columns. If you change the status to an equal match, then that also works properly. I hope that makes sense. --------------------------------------------------------------------- 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]
