[Libreoffice-bugs] [Bug 109409] TEXTJOIN and CONCAT ignore transposition of arrays passed to them

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=109409

--- Comment #11 from Eike Rathke <erack at redhat.com> ---
Looking at bug 97831 that discussed the implementation of TEXTJOIN() and
CONCAT() there's nothing that explicitly states the handling of order in
array/matrix cases. Also the Excel function help pages
https://support.microsoft.com/en-us/office/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c
and
https://support.microsoft.com/en-us/office/concat-function-9b1a9a3f-94ff-41af-9736-694cbd6b4ca2
do not explicitly mention any different than general behaviour.

I still think our column-wise handling is an implementation error.

Bug 99625 illustrates that not even the simple Excel online and full Excel
365/2016 agreed on array formulas (not related to array arguments though), so
any test case for this should be produced in the full-fledged Excel.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200819/d552af59/attachment.htm>