https://bugs.documentfoundation.org/show_bug.cgi?id=154125
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|0 |1 Status|UNCONFIRMED |ASSIGNED Summary|[ FILEOPEN ] [ FILESAVE ] |INDEX() does not return a |Behavior of Calc function |vector of an array if that |INDEX() in array-like cases |is only a vector, but only | |the first element --- Comment #1 from Eike Rathke <[email protected]> --- This is not a matter of load/save (adjusting summary). Also, it's not about array formula vs non-array formula. The formulas in the example document are explicitly stored as array formulas by Excel, hence Calc correctly displays them in {} curly braces. It's also not that in Calc one would have to enter an array formula for this MATCH() case to get a result if INDEX() worked correctly. It's simply that INDEX() does not return a column or row vector of an array that is already a single column or row vector. E.g. with , comma as array-column separator and ; semicolon as array-row separator: =INDEX({1;2};0;1) (all rows, column 1) should return {1;2} but returns 1 =INDEX({1,2};1;0) (row 1, all columns) should return {1,2} but returns 1 =INDEX({1;2};0;0) (all rows, all columns) correctly returns {1;2} =INDEX({1,2};0;0) (all rows, all columns) correctly returns {1,2} =INDEX({1;2};1;0) (row 1, all columns) correctly returns 1 =INDEX({1,2};0;1) (all rows, column 1) correctly returns 1 =INDEX({1,2;3,4};0;0) correctly returns {0,1;2,3} =INDEX({1,2;3,4};0;1) correctly returns {1;3} =INDEX({1,2;3,4};1;0) correctly returns {1,2} -- You are receiving this mail because: You are the assignee for the bug.
