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
Depends on:
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: ---

Document showing the Arrayformula described in this Issue (6.09 KB, application/octet-stream)
2004-09-21 08:23 UTC, frank
no flags Details

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

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

Modified slightly for Excel:

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

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


*** 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

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.