https://bugs.documentfoundation.org/show_bug.cgi?id=99625
GerardF <gerard.farg...@orange.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|TEXTEJOIN returns wrongly |TEXTJOIN returns wrongly an
|an array when "text |array when "text argument"
|argument" is a CSE array. |is a CSE array.
--- Comment #4 from GerardF <gerard.farg...@orange.fr> ---
(In reply to GerardF from comment #3)
> Dennis, can you try entering this formula in a cell:
> =TEXTJOIN(",
> ",1,INDEX(B:B,N(IF(1,MODE.MULT(IF(A4:A12=D4,{1,1}*ROW(A4:A12)))))))
> instead of
> =TEXTJOIN(", ",1,INDEX(B:B,MODE.MULT(IF(A4:A12=D4,{1,1}*ROW(A4:A12)))))
>
> in Excel and save the file as .xlsx
This formula was to make the same job, but you can test only a simple formula
like :
=TEXTJOIN(",",1,ROW(A1:A3))
--
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
