To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=35579
------- Additional comments from [EMAIL PROTECTED] Fri Aug 10 20:03:37 +0000 2007 ------- For QA purposes, when filtering: Begins-With "foo" now matches " foo" (leading whitespace ignored) Ends-With "foo" now matches "foo " (trailing whitespace ignored) When import/exporting Excel 97-2003 files, begins-with/ends-with/contains/does-not-contain is preserved: Excel (begins-with "foo") maps to (Begins with "foo") (and vice versa) Excel (ends-with "foo") maps to (Ends with "foo") (and vice versa) Excel (contains "foo.") maps to (Contains "foo.") (and vice versa) Excel (does-not-contain "foo") maps to (Does not Contain "foo") (and vice versa) Every Excel filter expression that contains a wildcard (*, ?) is mapped to a Calc filter expression using regular expressions: Excel (contains "foo*bar") maps to (Contains "foo.*bar"), regex enabled. Excel (contains "foo?bar") maps to (Contains "foo.bar"), regex enabled. Excel (contains "*foo*") maps to (Contains ".*foo.*"), regex enabled. Excel (contains "*foo.") maps to (Contains ".*foo\."), regex enabled. On export, only the regular expressions ".*" and "." are mapped to their corresponding Excel wildcard expressions. If a '\' (backslash) is found, it is removed (leaving the "escaped character" behind). Any other regular expression is _not_ handled: Calc (Contains "foo[[:space:]]*bar\.") is exported as "contains "foo[[:space:]]*bar." (and likely will be meaningless in Excel). This allows full fidelity when importing and exporting to an existing Excel spreadsheet as long as the filter expressions are not altered to use full regular expressions. --------------------------------------------------------------------- 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]
