To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83254 Issue #|83254 Summary|MATCH function works incorrectly for strings containin |g parentheses. Component|Spreadsheet Version|OOo 2.3 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|ydubinsky
------- Additional comments from [EMAIL PROTECTED] Fri Nov 2 15:00:51 +0000 2007 ------- I just have an example. There's the sheet with 6 cells. Column B contains the formula A B C Aa (2) =MATCH(A1;C$1:C$1;0) Aa 2 Aa (2) =MATCH(A2;C$2:C$2;0) Aa (2) I expect to see in the first row string values don't match and in the second row values match. But the result is opposit: A B C Aa (2) 1 Aa 2 Aa (2) #N/A Aa (2) I believe the problem somehow is related to regular expression parsing. After I manually added into content.xml file the following : <table:calculation-settings table:use-regular-expressions="false"/> (I found it in the file exported by Editgrid) the result becomes to be as expected: A B C Aa (2) #N/A Aa 2 Aa (2) 1 Aa (2) I tested it in OO 1 and OO 2. --------------------------------------------------------------------- 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]