https://bugs.documentfoundation.org/show_bug.cgi?id=153924
Bug ID: 153924
Summary: Calc functions SMALL() and LARGE() changed behavior
for array formulas
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: adylo811...@gmail.com
Sample data (starting from cell A1):
195 200 2
151 180 1
148 178 3
189 165 4
183 192 5
154 144
Note that cell C6 is blank empty; this is key to trigger the changed behavior.
Then use the following function, as array formula, CSE:
=SMALL(A1:B6,C1:C6)
Until LO 6.0 (at least):
148
144
151
154
165
Err:502
Same result is seen in AOO4113m1 (2022-07-01).
Excel returns a similar result.
But, since LO 7.0 (or maybe before that):
Err:504
Err:504
Err:504
Err:504
Err:504
Err:504
Similar changed behavior can be seen when using LARGE().
There are 3 things to note here:
A.
In old versions up until 6.0 (at least), the error is displayed on the relevant
cell only. Valid calculations are still shown. Since LO 7.0 (or before that),
_all_ cells display the error.
B. According to the Release Notes for LO 6.2, the Rank argument for Calc's
small() and large() functions did not support array values before, but I have
no problems using these functions and getting correct results when the Rank
argument is a range – tested in LO 3.3. So, I guess that the change in LO 6.2
not only affected actual inline array values being accepted, but also how these
functions react for corner cases / outside_of_scope data(?). Please note that
AOO4113m1 (current version ATM) behaves as older LO versions.
Unfortunately, currently I don't have LO 6.1 and/or 6.2 to test.
C.
* Err:502 means "Invalid argument". Reasonable.
* Err:504 means "Parameter list error". > Inadequate.
I'll attach a sample file soon.
--
You are receiving this mail because:
You are the assignee for the bug.
