To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=17995
------- Additional comments from [EMAIL PROTECTED] Sat Aug 30 16:50:57 +0000 2008 ------- Extending the filter offers only a limited functionality. A far more flexible way to extend the functionality is described in issue 66588. http://www.openoffice.org/issues/show_bug.cgi?id=66588 Having the ability to perform SQL-statements natively in Calc (without external data sources) is a way more flexible feature without any artificial limitations. The existing filter has 3 major limitations: 1.) limited categories (currently 3) 2.) limited string functionality 3.) no possibility to save and load filter settings Also, comparisons between 2 fields cannot be done and need to be pre-computed. Extending the filter to cover 4 fields is at most a minor enhancement. IF it is still desired to extend it, then a more comprehensive solution that permits an unlimited amount of rows is warranted: [FIELD] [CONDITION] [VALUE] [-] [OPERATOR] [FIELD] [CONDITION] [VALUE] [-] [ADD CONDITION] [DELETE CONDITION] [UNDO] Where: [-] Deletes the corresponding filter condition [ADD CONDITION] Adds another row to the filter [DELETE CONDITION] Similar to [-], deletes the condition that has the focus [UNDO] Undo last action (e.g. restores a deleted condition) IF less than 2 conditions remain, then 2 rows will be displayed, with one or both rows empty (as appropriate). --------------------------------------------------------------------- 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]
