[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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |mikekaganski at hotmail.com

--- Comment #12 from Eike Rathke <erack at redhat.com> ---
@Mike:
Can you please test this in Excel?
Values in A1:B2 (a1,b1,a2,b2)
Formula: =TEXTJOIN(",";;TRANSPOSE(A1:B2))
Result is
1) "a1,b1,a2,b2"
or
2) "a1,a2,b1,b2"

My guess is #2.

Similarly, an inline array
=TEXTJOIN(",";;{"a1","b1";"a2","b2"})
where the array column separator is , comma and the array row separator is ;
semicolon IMHO should return "a1,b1,a2,b2" (which in Calc currently returns
"a1,a2,b1,b2").

-- 
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/77220bda/attachment.htm>