openoffice-calc - 在 OO Calc 中连接一系列单元格

Question

我有这些单元格的 A 列:

A1: Apple
A2: Banana
A3: Cherry

我想要一个公式，将它们串在一个单元格中，如下所示:

"Apple, Banana, Cherry"

Answer 1

不知道是不是植入到 OpenOffice 但对他的表弟 LibreOffice Calc 从 5.2 版开始，您已经获得了以下功能:文本连接

TEXTJOIN( delimiter, skip_empty, string1[, string2][, …] )

delimiter is a text string and can be a range.

skip_empty is a logical (TRUE or FALSE, 1 or 0) argument. When TRUE, empty strings will be ignored.

string1[, string2][, …] are strings or references to cells or ranges that contains text to join.
Ranges are traversed row by row (from top to bottom).

示例:= 文本连接 ( "," , 1 , A1:A10 )

更多信息在这里:
https://help.libreoffice.org/6.3/en-US/text/scalc/01/func_textjoin.html?DbPAR=CALC#bm_id581556228060864