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

            Bug ID: 99625
           Summary: TEXTEJOIN returns wrongly an array when "text
                    argument" is a CSE array.
           Product: LibreOffice
           Version: 5.2.0.0.alpha1
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 124781
  --> https://bugs.documentfoundation.org/attachment.cgi?id=124781&action=edit
File with TEXTJOIN entered as array formula

TEXTJOIN(delimiter,skip empty cells,text) returns an array of cell when "text"
range is defined with a formula.

Example : =TEXTJOIN(", ",1,INDEX(A1:A10,{1;3;5})) returns "A1, A3, A5" (means
content of A1,A3 and A5) three times instead of one.

See attachment for a more detailled case.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to