Issue 77481

Summary: Find and Search Function return "#VALUE!" untestestable
Product: Calc Reporter: mikesberens <mikesberens>
Component: programmingAssignee: spreadsheet <spreadsheet>
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues, mikesberens
Version: OOo 2.0.4   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
BaySoxSched--SeeColumnC-forIssue-FindorSearch-NegRetrn none

Description mikesberens 2007-05-18 14:43:59 UTC 
Both the Find and Search functions (String; Targetcel; OptionalStartChar) to 
indicate a negative result return the pseudo value "#VALUE!" which seems 
untestable and irreplaceable.

The resultant pseudovalue cannot be tested, so neither Find nor Search is 
nestable within an IF function.  (Sample available -- upload instructions not 
evident).

The problem becomes frustrating in that the "#VALUE!" and the negative results 
have no elaboration in the OOo help files.
Comment 1 mikesberens 2007-05-18 14:46:04 UTC 
Created attachment 45220 [details]
BaySoxSched--SeeColumnC-forIssue-FindorSearch-NegRetrn
Comment 2 discoleo 2007-05-18 23:37:33 UTC 
This is a duplicate of issue 66590
(http://www.openoffice.org/issues/show_bug.cgi?id=66590). Please vote for that
one, so that the proposed enhancement gets implemented.
Comment 3 gercokees 2007-05-21 09:19:49 UTC 
closed duplicate

*** This issue has been marked as a duplicate of 66590 ***
Comment 4 oc 2008-07-15 21:37:05 UTC 
closed because duplicate