Bug 63408 - Unexpected result from SMALL or LARGE with array argument
Summary: Unexpected result from SMALL or LARGE with array argument
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
3.4.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
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:

Attachments
Add an attachment (proposed patch, testcase, etc.)

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 

=MAX(SMALL(D2:J2,{1;2})) 

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

=SUM(SMALL(D2:J2,{1;2})) 

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.