To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75987 Issue #|75987 Summary|regular expression in calc formula Component|Spreadsheet Version|1.0.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|claudiadzm
------- Additional comments from [EMAIL PROTECTED] Sun Apr 1 10:58:33 +0000 2007 ------- There is no possiblility for an "exact search" when using regex in formulas (or am I wrong?). For examle: =COUNTIF(A1:A200;".*s.*") makes no difference between "s" and "S". And it does not help to use instead =COUNTIF(A1:A200;".*[s].*") or =COUNTIF(A1:A200;".*[S].*") There should be a possibility to distinguish upper from lower. Greetings, Claudia --------------------------------------------------------------------- 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]