https://bugs.documentfoundation.org/show_bug.cgi?id=99625
--- Comment #2 from Winfried Donkers <[email protected]> --- The TEXTJOIN examples in attachment 124781 (File with TEXTJOIN entered as array formula) and attachment 124785 (Excel Online display) are - as the attachment says - entered as array formula. That means that the result will be an array. Calc produces the joined test strings and puts the result in 3 cells to create that array. Excel doesn't join the separate strings, disregards the delimiter and puts the input strings in 3 cells to create that array. IMHO this is a case which use is not supported by TEXTJOIN. But Excel nor Calc produce an error message. And that presents a problem: -the output from Excel is not correct, the result is not a concatenated text string with delimiters between the input strings; -the output from Calc differs from Excel. Which is 'better' is not important, interoperability is. However, it is a doubtful action to make Calc to provide an incorrect result because Excel does. If my reasoning is sound, one could state that Excel has bug (either not supporting array output or not producing a proper error output) and Calc has to follow as TEXTJOIN in Calc is there because it is in Excel. Should TEXTJOIN be added to the OpenFormula standard, the situation changes, Then Calc can comply with that standard. To make a long story short, I hesitate to confirm this bug report and don't have a solution other than waiting for definite information about the unexpected and AFAIK undocumented behaviour of TEXTJOIN in Excel. -- 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
