https://bugs.documentfoundation.org/show_bug.cgi?id=99625
Wolfgang Jäger <j...@psilosoph.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |j...@psilosoph.de
--- Comment #7 from Wolfgang Jäger <j...@psilosoph.de> ---
(In reply to Winfried Donkers from comment #2)
> The TEXTJOIN examples in attachment 124781 [details] (File with TEXTJOIN
> entered as array formula) and attachment 124785 [details] (Excel Online
> display) are - as the attachment says - entered as array formula. That means
> that the result will be an array.
>
...
This is simply wrong. Only the evaluated parameter(s) have to be passed to the
functions as arrays. Compare with accumulating numeric functions like PROD or
IMSUM (actually a kind of text-function). The functions will then have to
convert these arrays into sequences (See subchapter 4.11.12 of the mentioned
document). Of course, a function body may omit this and treat these sequences
as arrays for the sake of efficiency, if the results to obtain are not
distorted. Please read subchapter 3.3 of
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.odt . For
the data-parameters (all those of CONCAT and starting with the second one for
TEXTJOIN) we need a data type of "TextSequenceList" which is not yet specified,
but may be assumed in analogy to "NumberSequenceList" or "ComplexSequenceList".
The examples attached to bug#101137, in specific the reworked newer one should
be taken in account. If you think I should report the errors demonstrated and
explained there using orange background for highlighting as independent bugs
anew, please tell me. Given a few days I may also find the time to suggest a
complete extension to the mentioned specification with respect to this subject.
I may also sketch an implementation for CONCAT and TEXTJOIN in pseudocode or in
BASIC. (I cannot study and train in my late days everything needed to
contribute to the original code myself.)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs