To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90675 Issue #|90675 Summary|Calc: find and search functions return error on no-fin |d. Component|Spreadsheet Version|OOo 2.4.1 Platform|Macintosh URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|adrianh_hope
------- Additional comments from [EMAIL PROTECTED] Thu Jun 12 20:07:43 +0000 2008 ------- On a failed search, both functions return #VALUE!. To reproduce: 1. Enter in cell a formula with find text that will not be found in source text, for example: =FIND("ZZ";"source_text") 2. Observed: #VALUE! is returned. 3.Expected: Return value of zero or negative 1 (0 or -1). 4. Discussion: Cumbersome work-around example: =IF(ISERR(FIND("find_text";C2));0;FIND("find_text";C2)) Documentation does not address the return value for the no-find condition. Yes, this is how Microsoft Excel does it. It is a bug in Excel also, but I can't help them. ;-). Maybe we could have our own function, like AT(find,source) that returns zero on no-find. Thanks... --------------------------------------------------------------------- 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]