Issue 88967 - ODFF: PROB, FORECAST functions: scalar parameter evaluated as array
Summary: ODFF: PROB, FORECAST functions: scalar parameter evaluated as array
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 2.4.0
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-05-03 12:16 UTC by drking
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

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


Note You need to log in before you can comment on or make changes to this issue.
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.
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 "".