Issue 34324 - SEARCH() Not Functiong w/ Nesting & Arrays
Summary: SEARCH() Not Functiong w/ Nesting & Arrays
Status: CLOSED DUPLICATE of issue 20494
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1.2
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-09-18 01:34 UTC by fxer
Modified: 2004-09-21 08:26 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Document showing the Arrayformula described in this Issue (6.09 KB, application/octet-stream)
2004-09-21 08:23 UTC, frank 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description fxer 2004-09-18 01:34:19 UTC 
{=SUM(IF(ISERROR(SEARCH("Mark";A1:A10));0;1))}

For some reason, the above sum isn't actually counting the instances of "Mark"
in A1:A10 in OO.org

Modified slightly for Excel:
{=SUM(IF(ISERROR(SEARCH("Mark",A1:A10)),0,1))}

This DOES give the sum for the number of "Mark" instances in A1:A10

PS: I realize there are much easier ways to accomplish a simple counting, this
is just a fragment of a larger function :)
Comment 1 frank 2004-09-20 10:42:15 UTC 
Hi,

this is fixed with Issue 20494. Therefore I set this Issue as double to it.

Frank

*** This issue has been marked as a duplicate of 20494 ***
Comment 2 frank 2004-09-20 10:42:29 UTC 
closed double
Comment 3 frank 2004-09-21 08:23:41 UTC 
Created attachment 17826 [details]
Document showing the Arrayformula described in this Issue
Comment 4 frank 2004-09-21 08:26:13 UTC 
Hi,

the attached file should show the formula your using. Opening it with OOo1.1.2
gives the wrong result. Using OOo1.9.51 or later will result in the correct
result, four.

Issues flaged with target OOo2.0 will not be fixed in the OOo1.1 codeline.

Frank