diff options
| author | Eike Rathke <erack@redhat.com> | 2021-03-22 14:34:00 +0100 |
|---|---|---|
| committer | Eike Rathke <erack@redhat.com> | 2021-03-22 14:37:26 +0100 |
| commit | 9ab43b71fc1e5e92489f206a515d6f35bf4fd883 (patch) | |
| tree | dcef492bf182449934558ff0d5e5a27f0eaa56fd | |
| parent | c53347c0b4d7b2f5ed784e4ad0c03984aeb68999 (diff) | |
Use ; semicolon instead of , comma function parameter separator
And don't use localized TRUE number word. Either TRUE() function or 1
number.
Change-Id: I7d2cacd95524ed54316cb623990a4c5a96b53067
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/112891
Reviewed-by: Eike Rathke <erack@redhat.com>
Tested-by: Jenkins
| -rw-r--r-- | source/text/scalc/01/func_textjoin.xhp | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/source/text/scalc/01/func_textjoin.xhp b/source/text/scalc/01/func_textjoin.xhp index 7a610bb6d2..ed3e13b674 100644 --- a/source/text/scalc/01/func_textjoin.xhp +++ b/source/text/scalc/01/func_textjoin.xhp @@ -35,8 +35,8 @@ <paragraph role="paragraph" id="par_id831556228543099">If there are more delimiters than strings to be joined, not all delimiters will be used.</paragraph> <paragraph role="paragraph" id="par_id321556228557611">If there are less delimiters than strings to be joined, the delimiters will be used again from the start.</paragraph> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> - <paragraph role="paragraph" id="par_id441556229012536"><input>=TEXTJOIN(" ",TRUE, "Here", "comes", "the", "sun")</input> returns "Here comes the sun" with space character as delimiter and empty strings are ignored.</paragraph> - <paragraph role="paragraph" id="par_id441556239012536">if A1:B2 contains "Here", "comes", "the", "sun" respectively, <input>=TEXTJOIN("-",TRUE,A1:B2)</input> returns "Here-comes-the-sun" with dash character as delimiter and empty strings are ignored.</paragraph> + <paragraph role="paragraph" id="par_id441556229012536"><input>=TEXTJOIN(" "; 1; "Here"; "comes"; "the"; "sun")</input> returns "Here comes the sun" with space character as delimiter and empty strings are ignored.</paragraph> + <paragraph role="paragraph" id="par_id441556239012536">if A1:B2 contains "Here", "comes", "the", "sun" respectively, <input>=TEXTJOIN("-";1;A1:B2)</input> returns "Here-comes-the-sun" with dash character as delimiter and empty strings are ignored.</paragraph> <section id="relatedtopics"> <embed href="text/scalc/01/func_concat.xhp#concatfunct"/> <paragraph role="paragraph" id="par_id781556244709752"><link href="text/scalc/01/04060110.xhp#concatenate" name="concatenate">CONCATENATE</link></paragraph> |