To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=88967 Issue #|88967 Summary|PROB, FORECAST functions: scalar evaluation of array p |arameter Component|Spreadsheet Version|OOo 2.4.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|programming Assigned to|spreadsheet Reported by|drking
------- Additional comments from [EMAIL PROTECTED] Sat May 3 11:16:32 +0000 2008 ------- 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. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
