Issue 93915

Summary: ISFORMULA fails in array-context and SUMPRODUCT
Product: Calc Reporter: villeroy <villeroy>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.4.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Spreadsheet formulas related to issue 93915 none

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".