<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - TEXTJOIN and CONCAT ignore transposition of arrays passed to them" href="https://bugs.documentfoundation.org/show_bug.cgi?id=109409#c5">Comment # 5</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - TEXTJOIN and CONCAT ignore transposition of arrays passed to them" href="https://bugs.documentfoundation.org/show_bug.cgi?id=109409">bug 109409</a> from <a class="email" href="mailto:jag@psilosoph.de" title="Wolfgang Jäger <jag@psilosoph.de>"> Wolfgang Jäger</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>