Bug 63408 - Unexpected result from SMALL or LARGE with array argument
Summary: Unexpected result from SMALL or LARGE with array argument
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
(earliest affected)
3.4.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2013-04-11 00:59 UTC by Dave Dixon
Modified: 2013-04-11 22:19 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Dave Dixon 2013-04-11 00:59:26 UTC
One would expect that the formula 


would return the same as SMALL(D2:J2,2) (the second smallest value). And that


would return the sum of the two smallest values. However, SMALL seems to look at only the first element of the array argument. The same seems to be the case for LARGE.
Comment 1 GerardF 2013-04-11 10:04:42 UTC
This always works for me with all versions.
Did you enter the formula as array formula (Ctrl+Shift+Enter) ?
Comment 2 Dave Dixon 2013-04-11 22:19:50 UTC
Indeed, it does work entered as an array (Ctrl+Shift+Enter). Sorry, I thought I'd tried that.