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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Aug 19 19:03:00 UTC 2020


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

--- Comment #13 from Mike Kaganski <mikekaganski at hotmail.com> ---
Unfortunately, I only have Excel 2016 (TEXTJOIN appeared only in Excel 2019).

But Office Online (available in my profile) gives this:

=TEXTJOIN(",";;TRANSPOSE(A1:B2)) => a1,a2,b1,b2
=TEXTJOIN(",";;{"a1","b1";"a2","b2"}) => gives unspecified error (just marks
the cell with red border, without any hints anywhere, possibly due to Online
version limitations).

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


More information about the Libreoffice-bugs mailing list