Issue 93915 - ISFORMULA fails in array-context and SUMPRODUCT
Summary: ISFORMULA fails in array-context and SUMPRODUCT
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 2.4.1
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-09-15 15:58 UTC by villeroy
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

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

Attachments
Spreadsheet formulas related to issue 93915 (22.84 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-09-15 16:07 UTC, villeroy 		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 villeroy 2008-09-15 15:58:36 UTC 
{=ISFORMULA(vector)}
=SUMPRODUCT(ISFORMULA(vector))
... fail, whereas ISNUMBER and ISTEXT seem to work in this context.
Comment 1 villeroy 2008-09-15 16:07:19 UTC 
Created attachment 56545 [details]
Spreadsheet formulas related to issue 93915
Comment 2 villeroy 2008-09-15 16:12:20 UTC 
Side note: The attached sheet demostrates another issue I filed as
http://www.openoffice.org/issues/show_bug.cgi?id=93916
Comment 3 jeffooo 2009-09-13 20:06:30 UTC 
I confirm on OOo3.1.1 and DEV300m55

Steps to reproduce :
- in A1 to A5, input text, numbers and formulas
- in B1 :
=ISFORMULA(A1:A5)
and valid with Ctrl+Shift+Enter (matrix validation)
The expect résult is false...

Another function with same bad résult :
=FORMULA(A1:A5)
and valid with Ctrl+Shift+Enter (matrix validation)
The expect résult is false...

Now, it's not possible to calculate formula's quantity in sheets.

Regards
Comment 4 ooo 2009-09-23 16:16:16 UTC 
Grabbing issue.

Note that SUMPRODUCT forces its arguments into array context, so the underlying
cause is identical.
Comment 5 yrouillard 2010-04-17 23:24:57 UTC 
I also confirm this bug.

The TYPE function seems to be also affected.
Comment 6 yrouillard 2010-04-17 23:33:44 UTC 
The FORMULE function is also affected.
Comment 7 Marcus 2017-05-20 11:11:18 UTC 
Reset assigne to the default "issues@openoffice.apache.org".