https://bugs.documentfoundation.org/show_bug.cgi?id=171017
--- Comment #19 from ady <[email protected]> --- @Colin, My opinion is that the result of an array formula should be maintained together, as an array. In this case, each row within S2:Y282 is an array (281 vectors, 1 row x 7 columns each). You can _filter_ the list (which does not modify any of the horizontal vectors), but changing the order of the list by sorting according to one component of the 281 vectors would break the arrays. Let's assume that Z2 has a value of 932. Then, according to the INDEX() array, the range S2:Y2 should be: 4; 5; 26; 38; 48; 2; 9. What happens when, starting with this situation, you decide to sort in ascending order by column S (S2:S282)? You would still have Z2: 932, but the array S2:Y2 would not correspond to the value in Z2, because S2 would no longer be 4. An alternative, IMHO, would be to avoid the array formula, producing instead independent INDEX() functions. IDK if that answers your question. I would suggest opening a discussion at <https://ask.libreoffice.org> or in some forum dedicated to spreadsheet tools. Maybe someone has a different opinion, or can suggest a different method so as to be able to sort by components without breaking the array functions (e.g perhaps by using some of the newer functions introduced in recent versions of Calc, when you are eventually able to update to such newer version). I am not saying I am recommending anything in particular, or that it is even possible; just that someone could have enough experience that might be able to suggest a different approach. -- You are receiving this mail because: You are the assignee for the bug.
