https://bugs.documentfoundation.org/show_bug.cgi?id=154125
--- Comment #2 from Eike Rathke <[email protected]> --- Note that in Excel the cases =INDEX({1;2};0;0) =INDEX({1,2};0;0) =INDEX({1,2;3,4};0;0) with both row_num=0 and column_num=0 that they document to not work at all and return error. There is no compelling reason though why it shouldn't and it works in Calc. Additionally there is a working case that they do not document, if the array is a one-dimensional row vector then if column_num is not given then the row_num argument acts as a column index. E.g. =INDEX({1,2};2) returns 2, as does =INDEX({1,2};0;2) That is specified by ODFF v1.3 in 6.14.6 INDEX https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#INDEX -- You are receiving this mail because: You are the assignee for the bug.
