summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSteve Fanning <stevemfanning@yahoo.co.uk>2021-05-28 21:47:18 +0200
committerOlivier Hallot <olivier.hallot@libreoffice.org>2021-05-30 00:02:35 +0200
commitd443ebed5df323aa13c2f5fa505b98366d8a4f9c (patch)
treef4c2fec9f55f80dd96edcf1f89c29e2022d41dfe
parent96e26682870d3032dc0cccc6ed0a580f22111998 (diff)
Fix help description for Calc's TEXTJOIN function.
Change-Id: I91bb809ab41c0299c65236a0091c2da288a47b31 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/116163 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
-rw-r--r--source/text/scalc/01/func_textjoin.xhp2
1 files changed, 1 insertions, 1 deletions
diff --git a/source/text/scalc/01/func_textjoin.xhp b/source/text/scalc/01/func_textjoin.xhp
index ed3e13b674..b7f04904d9 100644
--- a/source/text/scalc/01/func_textjoin.xhp
+++ b/source/text/scalc/01/func_textjoin.xhp
@@ -28,7 +28,7 @@
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
<paragraph role="code" id="par_id541556228253979">TEXTJOIN( delimiter, skip_empty, String 1[; String 2][; … ;[String 253]] )</paragraph>
<paragraph role="paragraph" id="par_id741556228390897"><emph>delimiter</emph> is a text string and can be a range.</paragraph>
- <paragraph role="paragraph" id="par_id621556228397269"><emph>skip_empty</emph> is a logical (TRUE or FALSE, 1 or 0) argument. When TRUE, empty strings will be ignored.</paragraph>
+ <paragraph role="paragraph" id="par_id621556228397269"><emph>skip_empty</emph> is a logical argument. When set to FALSE or 0, empty strings will be taken into account and this may lead to adjacent delimiters in the returned string. When set to any other value (e.g. TRUE or 1), empty strings will be ignored.</paragraph>
<paragraph role="paragraph" id="par_id631556228516997"><emph>String 1[; String 2][; … ;[String 253]]</emph> are strings, references to cells or to cell ranges of strings.</paragraph>
<paragraph role="paragraph" id="par_id1001556228523394">Ranges are traversed row by row (from top to bottom).</paragraph>
<paragraph role="paragraph" id="par_id81556228530082">If <emph>delimiter</emph> is a range, the range need not be of the same size as the number of strings to be joined.</paragraph>