[sc-issues] [Issue 90675] Calc: find and search func tions return error on no-find.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90675 User redflagzhulihua changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |DUPLICATE --- Additional comments from [EMAIL PROTECTED] Fri Aug 22 09:44:33 + 2008 --- Duplicate of issue 66590 *** This issue has been marked as a duplicate of 66590 *** - 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]
[sc-issues] [Issue 90675] Calc: find and search func tions return error on no-find.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90675 User redflagzhulihua changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from [EMAIL PROTECTED] Fri Aug 22 09:45:13 + 2008 --- closed - 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]
[sc-issues] [Issue 90675] Calc: find and search func tions return error on no-find.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90675 --- Additional comments from [EMAIL PROTECTED] Mon Aug 18 02:33:13 + 2008 --- Hi adrianh_hope, This issue has been submitted in #66590 by Discoleo . Thanks all the same. - 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]
[sc-issues] [Issue 90675] Calc: find and search func tions return error on no-find.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90675 --- Additional comments from [EMAIL PROTECTED] Fri Jun 13 20:58:42 + 2008 --- This is probably a duplicate of issue 66590 http://www.openoffice.org/issues/show_bug.cgi?id=66590 Definitely should NOT be closed as WORKSFORME (as many other doubles were closed). - 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]
[sc-issues] [Issue 90675] Calc: find and search func tions return error on no-find.
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 + 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]