https://bugs.freedesktop.org/show_bug.cgi?id=63408
Priority: medium
Bug ID: 63408
Assignee: [email protected]
Summary: Unexpected result from SMALL or LARGE with array
argument
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 3.4.3 release
Component: BASIC
Product: LibreOffice
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
