https://bugs.documentfoundation.org/show_bug.cgi?id=172440
Bug ID: 172440
Summary: TAKE function misbehaviour in corner cases
Product: LibreOffice
Version: 26.8.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
The Calc TAKE function was implemented in bug#150997 and provides the correct
result except for:
* If the number of rows or columns to TAKE is greater than the number of rows
and columns of the source array, the resulting array is limited to the size of
the source array. This is questionable, no warnings.
* When 'aaa' is a named range
+ {=TAKE(aaa,0,0)} returns #N/A, should be "illegal argument" error
+ {=TAKE(aaa,,0)} returns #N/A, should be "illegal argument" error
+ {=TAKE(aaa,0)} returns #N/A, should be "illegal argument" error
* Note: When 'aaa' is a named range
+ {TAKE(aaa)} returns a copy of the source array (Rows and Columns omitted)
+ Excel 365 returns an error.
* Note: 'Rows' parameter is mandatory for Excel 365 and optional for LO.
Code pointer is
https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/interpr1.cxx?r=114bc67a2d2f1b9f84f68a3f3d1a93077ef4e369#8829
--
You are receiving this mail because:
You are the assignee for the bug.
