Issue 101995 - Array Formula; Max/Min Conditional Calculation Error
Summary: Array Formula; Max/Min Conditional Calculation Error
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.4.1
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2009-05-16 21:57 UTC by mikegsmith
Modified: 2013-01-29 21:40 UTC (History)
2 users (show)

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

Arrays - Max/Min Conditional Calculation Error (12.08 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-05-16 22:03 UTC, mikegsmith
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description mikegsmith 2009-05-16 21:57:41 UTC
Documentation/How Tos/Using Arrays, p. 5 under Tips and Tricks ("Maximum in a
particular month")

Following described formula provides correct result:
Documentation says that the Min() function would provide the minimum value for
the month. However, following formula does not produce meaningful result:

Small() and Large() functions will work in this instance.
Comment 1 mikegsmith 2009-05-16 22:03:27 UTC
Created attachment 62316 [details]
Arrays - Max/Min Conditional Calculation Error
Comment 2 Regina Henschel 2009-05-17 22:02:21 UTC
In MIN you use
which sets the result to 0, if MONTH() unequal 5. Therefore the minimum is 0.

In SMALL you use
which is a form with only two parameters. It sets the result to the default
FALSE, if MONTH() unequal 5. Therefore the smallest is 28.

will work as

But the question is, why FALSE is not evaluated as 0 in array context. I set
this issue to new, so that Eike can look, whether this is conform to ODF spec.