source/text/scalc/01/func_textsplit.xhp | 15 ++++++++-------
1 file changed, 8 insertions(+), 7 deletions(-)
New commits:
commit a849732e3fca989e387de7cd2272c53a792d5ba3
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sun May 11 11:36:47 2025 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Sun May 11 16:38:32 2025 +0200
About optional arguments in TEXTSPLIT function.
Change-Id: Ia3ce48c3fce1c7aeb3e3d72dd3e8ca32dd816c59
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/185187
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/func_textsplit.xhp
b/source/text/scalc/01/func_textsplit.xhp
index 9be60312c5..535c7b694b 100644
--- a/source/text/scalc/01/func_textsplit.xhp
+++ b/source/text/scalc/01/func_textsplit.xhp
@@ -24,15 +24,16 @@
<h1 id="hd_id551556227727946"><variable id="textsplitfunct"><link
href="text/scalc/01/func_textsplit.xhp">TEXTSPLIT</link></variable></h1>
<paragraph id="par_id121556227727948" role="paragraph"><variable
id="textsplitfunction">Splits text by a given delimiter to an array of multiple
cells.</variable></paragraph>
</section>
+ <embed href="text/scalc/01/common_func.xhp#array"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
<paragraph role="code" id="par_id541556228253979">TEXTSPLIT(Text; Column
Delimiter; Row Delimiter; Ignore Empty; Match Mode; Pad With)</paragraph>
- <paragraph role="paragraph" id="par_id741746962354423"><emph>Text</emph>:
the text to split.</paragraph>
- <paragraph role="paragraph" id="par_id91746962359992"><emph>Column
Delimiter</emph>: the text to delimit the columns. Multiple delimiters can be
supplied.</paragraph>
- <paragraph role="paragraph" id="par_id361746962365647"><emph>Row
Delimiter</emph>: the text to delimit the rows. Multiple delimiters can be
supplied.</paragraph>
- <paragraph role="paragraph" id="par_id521746962371799"><emph>Ignore
Empty</emph>: set to TRUE to ignore consecutive delimiters otherwise creates an
empty cell. The default to FALSE.</paragraph>
- <paragraph role="paragraph" id="par_id951746962377042"><emph>Match
mode</emph>: set to 1 to perform a case-insensitive match otherwise does a
case-sensitive match. The default to 0.</paragraph>
- <paragraph role="paragraph" id="par_id651746962382871"><emph>Pad
with</emph>: the value with which to pad. The default is #N/A.</paragraph>
-
+ <paragraph role="paragraph" id="par_id741746962354423"><emph>Text</emph>:
(optional) the text to split.</paragraph>
+ <paragraph role="paragraph" id="par_id91746962359992"><emph>Column
Delimiter</emph>: (optional) the text to delimit the columns. Multiple
delimiters can be supplied.</paragraph>
+ <paragraph role="paragraph" id="par_id361746962365647"><emph>Row
Delimiter</emph>: (optional) the text to delimit the rows. Multiple delimiters
can be supplied.</paragraph>
+ <paragraph role="paragraph" id="par_id521746962371799"><emph>Ignore
Empty</emph>: (optional) set to TRUE to ignore consecutive delimiters otherwise
creates an empty cell. The default to FALSE.</paragraph>
+ <paragraph role="paragraph" id="par_id951746962377042"><emph>Match
mode</emph>: (optional) set to 1 to perform a case-insensitive match otherwise
does a case-sensitive match. The default to 0.</paragraph>
+ <paragraph role="paragraph" id="par_id651746962382871"><emph>Pad
with</emph>: (optional) the value with which to pad. The default is
#N/A.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#optional_args"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
<paragraph role="paragraph" id="par_id521746970153871">If cell A1 contains
<literal>"AA,BB,,CC/DD,EE,FF/GG,HH,II,JJ"</literal>, then </paragraph>
<paragraph role="paragraph"
id="par_id541746969982707"><input>{=TEXTSPLIT(A1;",";"/";FALSE();1;"@@@")}</input>
returns the following array:</paragraph>
