[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 #5 from Wolfgang Jäger <jag at psilosoph.de> ---
Concerning V 6.1.1.2: Behaviour unchanged.

Additional considerations:
There is no specification for the functions CONCAT and TEXTJOIN in
OpenFormula_1.2. The de-facto specification is "Do as Excel 2016 does!".  

Trying to shape probable specifications in a way analogous to the
specifications of numerical accumulating functions (SUM, COUNT, PRUDUCT, ...) I
came to the conclusion that there would be needed (at least) additional types
like 'TextSequence' and 'TextSequenceList' to do so.  

Concerning conversion to NumberSequence, NumberSequenceList and related types
(See OpenFormula_1.2. subchapters 6.3.7 through 6.3.9 and 6.3.11) there is no
specification regarding order. Since all the operations to perform in these
cases are (extended) commutative in math (NOT exactly in machine arithmetic!)
such a specification may be assumed obsolete. Concerning concatenation there is
no commutativity.  

Anyway, regarding the term, a sequence is not the same as a set, and any
technical accumulation will be a serial process in time. Therefore conversion
(of results gotten by range references e.g.) to sequence should explicitly
specify an order explicitly.

-- 
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/20180924/8137241e/attachment-0001.html>