To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72904 Issue #|72904 Summary|Regular Expression Fails Component|Spreadsheet Version|OOo 2.0.4 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|hwfa
------- Additional comments from [EMAIL PROTECTED] Sat Dec 23 01:22:40 -0800 2006 ------- Consider the following small spreadsheet (3 columns, 6 rows, all numbers are *data*): 1 1 13 2 3 14 3 9 15 4 8 20 5 7 45326 6 6 65421 The requirement is to highlight values 1, 3 and 6. The regular Expression (RE) that *should* do this is "^1$|^3$|^6$" (without the quotes). This *only* finds the value 1; the 3 and 6 are not found. If we leave out the ^ and $ characters, we find the values but we also find 13, 14, 15, 45326 and 65421 which is not what is required. If, starting with the original RE, we leave out only the $ symbols, then we don't find 3 or 6 (or 65421). First found in OOo 2.0.4 but completely reproducible in 2.1 --------------------------------------------------------------------- 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]
