Issue 88967

Summary: ODFF: PROB, FORECAST functions: scalar parameter evaluated as array
Product: Calc Reporter: drking <openoffice>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues
Version: OOo 2.4.0   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description drking 2008-05-03 12:16:32 UTC 
A    B
1   3    0.7
2   4    0.3

=ABS(A1:A2) entered in cell C3 in scalar (non-array) mode correctly returns 
#VALUE! because there is no intersection between C3 and A1:A2 

=PROB(A1:A2;B1:B2;A1:A2) entered in cell C3 in scalar (non-array) mode should 
surely also return #VALUE! for the same reason, but returns 0.7. It's as if 
A1:A2 is treated as an inline array not a range.

A similar thing happens with FORECAST.

These two functions have ForceArray parameters as well as a single parameter, 
which may be relevant. The only other function with this combination is TTEST.

Not the most important issue, so I've suggested P4. However it doesn't seem to 
comply with ODFF so ought to be on the list.
Comment 1 ooo 2008-06-25 11:53:43 UTC 
Actually that is even specified in ODFF:

PROB( ForceArray Array Data ; ForceArray Array Probability ; Number Start [ ;
Number End ] )

FORECAST( Number Value ; ForceArray NumberSequence Data_X ; ForceArray
NumberSequence Data_Y )
Comment 2 ooo 2008-06-25 11:54:08 UTC 
Closing invalid.
Comment 3 ooo 2008-06-26 11:09:49 UTC 
Sorry, I was mistaken. Yes, indeed, the 3rd parameter to PROB, A1:A2, should not
be interpreted as an array, so the function should return an error instead.
Reopening.
Comment 4 ooo 2008-06-26 11:14:11 UTC 
Grabbing issue.
Comment 5 Marcus 2017-05-20 11:11:19 UTC 
Reset assigne to the default "issues@openoffice.apache.org".