[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 #9 from Wolfgang Jäger <jag at psilosoph.de> ---
(In reply to Eike Rathke from comment #8)
> Taking a look at the implementation it indeed iterates all rows for each
> column for the array/matrix case. I think this is simply an implementation
> error, unless someone can spot the same behaviour in Excel..

I well remember that TEXTJOIN and CONCAT originally were dedicated to
compatibility with Excel, and that there were a few months of discussions about
the doubtable implementations owed to that fact.

The idea of sticking to the original implementation in case it was proven to
behave as the functions did in Exel looked absurd to me then, because what was
claimed to be returned by Excel under array-evaluation was so absurd. 

Now the issue is clearly less serious. Nonetheless the question if "compatible"
should be preferred over "good and consistent" deserves thorough consideration
in every case.

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