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