From The Document Foundation Wiki
Jump to: navigation, search
  • Changed since 7.0.1
    : TEXTJOIN() and CONCAT() now handle array/matrix arguments row-wise instead of column-wise, to behave the same as for cell range references and interoperability with other implementations. If formula expressions relied on the old erroneous behaviour that an internal matrix with two columns or more was processed column-wise, they must be changed to pass a transposed matrix to achieve the same (e.g. old CONCAT({"a","b";"c","d"}) would now have to be CONCAT(TRANSPOSE({"a","b";"c","d"})) for the same acbd result). Again, this change is only for the array/matrix case, cell reference arguments are not affected. tdf#109409 (Eike Rathke (Red Hat, Inc.))