diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2019-04-25 23:42:20 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2019-04-27 14:08:21 +0200 |
| commit | 7b20c74a33942157b02b99353aa98e45f7c0a111 (patch) | |
| tree | 96a7a6f07cb29672409942dc3c02c2a84b876cb6 /source/text/scalc/01/func_textjoin.xhp | |
| parent | tdf#123803 Add release info in Calc functions (diff) | |
| download | help-7b20c74a33942157b02b99353aa98e45f7c0a111.tar.gz help-7b20c74a33942157b02b99353aa98e45f7c0a111.zip | |
tdf#99517 help for CONCAT, TEXTJOIN, IFS, SWITCH
CONCAT, TEXTJOIN, IFS, SWITCH
Change-Id: Ic1d74ac8b810bd0c0d4b4f570baab1d1e270f912
Reviewed-on: https://gerrit.libreoffice.org/71339
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/01/func_textjoin.xhp')
| -rw-r--r-- | source/text/scalc/01/func_textjoin.xhp | 45 |
1 files changed, 45 insertions, 0 deletions
diff --git a/source/text/scalc/01/func_textjoin.xhp b/source/text/scalc/01/func_textjoin.xhp new file mode 100644 index 0000000000..0b24f81614 --- /dev/null +++ b/source/text/scalc/01/func_textjoin.xhp @@ -0,0 +1,45 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + + <meta> + <topic id="textjoinfunc" indexer="include" status="PUBLISH"> + <title id="tit" xml-lang="en-US">TEXTJOIN function</title> + <filename>/text/scalc/01/func_textjoin.xhp</filename> + </topic> + </meta> + <body> + <section id="textjoin01"> + <bookmark id="bm_id681556227727944" xml-lang="en-US" branch="hid/SC_HID_FUNC_TEXTJOIN_MS" localize="false"/> + <bookmark xml-lang="en-US" branch="index" id="bm_id581556228060864"> + <bookmark_value>TEXTJOIN function</bookmark_value> + </bookmark> + <h2 id="hd_id551556227727946"><variable id="textjoinfunct"><link href="text/scalc/01/func_textjoin.xhp" name="textjoinfunction">TEXTJOIN</link></variable></h2> + <paragraph id="par_id121556227727948" role="paragraph"><variable id="textjoinfunction"><ahelp hid=".">Concatenates one or more strings, and uses delimiters between them.</ahelp></variable></paragraph> + </section> + <embed href="text/scalc/00/avail_release.xhp#5.2"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> + <paragraph role="code" id="par_id541556228253979">TEXTJOIN( delimiter, skip_empty, string1[, string2][, …] )</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_id631556228516997"><emph>string1[, string2][, …]</emph> are strings or references to cells or ranges that contains text to join.</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> + <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> + <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> + </section> +</body> +</helpdocument> |