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.