https://bugs.documentfoundation.org/show_bug.cgi?id=99625
--- Comment #3 from GerardF <[email protected]> --- As I said before, I don't have Excel and so can't do more test. Excel show an array of 3 rows because Calc have store this formula like this. Wrong result in Excel were expected. When INDEX have a array as row or column argument, the result of INDEX is not handled properly in another function in array formula in Excel. That's a known bug. A way to force Excel to recognize the result of INDEX as an array is to force the recognition with N (or T in case of text) and IF. Dennis, can you try entering this formula in a cell: =TEXTJOIN(", ",1,INDEX(B:B,N(IF(1,MODE.MULT(IF(A4:A12=D4,{1,1}*ROW(A4:A12))))))) instead of =TEXTJOIN(", ",1,INDEX(B:B,MODE.MULT(IF(A4:A12=D4,{1,1}*ROW(A4:A12))))) in Excel and save the file as .xlsx -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
