To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=32344
------- Additional comments from [EMAIL PROTECTED] Fri Jan 11 21:59:26 +0000 2008 ------- Text comparison in Calc occurs in 1. Formulas by operator =A1=B1 2. Functions like MATCH etc. 3. Filters 4. Find/Replace It is influenced by following options: - Calc>Calculation>Case sensitive (affects 1. only) - Calc>Calculation>Search criteria = and <> must apply to whole cells (affects 2. and 3.) - Enable regular expressions in formulas (affects 2. only, but not 1.) Better labeled "Enable regular expressions in function arguments"? Filters, SortDescriptors and Find/Replace have their own options for regex and case. There are too many options and implications. The behaviour is inconsistent. For instance: Did anybody notice that case-insensitive cell values obsoletes many benefits of regular expressions? My radical proposal: One option to toggle between native mode and compatibility mode. Native mode: All strings in Calc are case sensitive and support regular expressions, "=" and "<>" do not apply to whole cells unless you use them with "^" and "$". Compatibility mode: Excel files are loaded in compatibility mode: All strings are case-insensitive except for EXACT and FIND. They support wildcards. "=" and "<>" apply to whole cells. --------------------------------------------------------------------- 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]