AllLangHelp_scalc.mk | 2 +
source/text/scalc/01/func_textafter.xhp | 50 +++++++++++++++++++++++++++++++
source/text/scalc/01/func_textbefore.xhp | 50 +++++++++++++++++++++++++++++++
source/text/scalc/01/func_textsplit.xhp | 4 +-
4 files changed, 104 insertions(+), 2 deletions(-)
New commits:
commit 68f45944fe1f7228736f82e41cddb056e165f7cb
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Mon May 12 14:18:47 2025 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Tue May 13 12:58:16 2025 +0200
tdf#150865 Help page for TEXTAFTER function
Change-Id: I5f24fddb1c515d1dc3a0454a38f553b041eda9aa
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/185230
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 8511fa7d5f..62e1a7c661 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -314,6 +314,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_sumif \
helpcontent2/source/text/scalc/01/func_sumifs \
helpcontent2/source/text/scalc/01/func_switch \
+ helpcontent2/source/text/scalc/01/func_textafter \
helpcontent2/source/text/scalc/01/func_textbefore \
helpcontent2/source/text/scalc/01/func_textjoin \
helpcontent2/source/text/scalc/01/func_textsplit \
diff --git a/source/text/scalc/01/func_textafter.xhp
b/source/text/scalc/01/func_textafter.xhp
new file mode 100644
index 0000000000..26ba2104a2
--- /dev/null
+++ b/source/text/scalc/01/func_textafter.xhp
@@ -0,0 +1,50 @@
+<?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="text/scalc/01/func_textafter.xhp" indexer="include"
status="PUBLISH">
+ <title id="tit">TEXTAFTER function</title>
+ <filename>/text/scalc/01/func_textafter.xhp</filename>
+ </topic>
+</meta>
+<body>
+<bookmark id="bm_id921747059635186" branch="hid/SC_HID_FUNC_TEXTAFTER_MS"
localize="false"/>
+<bookmark branch="index" id="bm_id581556228060864">
+<bookmark_value>TEXTAFTER function</bookmark_value>
+</bookmark>
+<section id="section identification">
+ <h1 id="hd_id451747059635188"><variable id="h1"><link
href="text/scalc/01/func_textafter.xhp">TEXTAFTER</link></variable></h1>
+ <paragraph id="par_id381747059635191" role="paragraph">Returns the text
that occurs after a given substring or delimiter.</paragraph>
+</section>
+<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
+<paragraph role="code" id="par_id541556228253979">TEXTAFTER( Text [; Delimiter
[; Instance Number [; Match Mode [; Match End [; If Not Found ]]]]])</paragraph>
+<paragraph role="paragraph" id="par_id91747066169381"><emph>Text</emph>: the
original text.</paragraph>
+<paragraph role="paragraph" id="par_id221747066174430"><emph>Delimiter</emph>:
(optional) the delimiter. Multiple delimiters can be supplied.</paragraph>
+<paragraph role="paragraph" id="par_id821747066179393"><emph>Instance
Number</emph>: (optional) the instance of the delimiter after which to extract
text. The default is 1. A negative number starts searching from the
end.</paragraph>
+<paragraph role="paragraph" id="par_id121747066183422"><emph>Match
Mode</emph>: (optional) set to 1 to perform a case-insensitive match. The
default is 0.</paragraph>
+<paragraph role="paragraph" id="par_id201747066188182"><emph>Match End</emph>:
(optional) set to 1 to treat the end of text as a delimiter. The default is
0.</paragraph>
+<paragraph role="paragraph" id="par_id701747066192253"><emph>If Not
Found</emph>: (optional) the value returned if no match is found. 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_id21747067698384"><input>=TEXTAFTER("To be
or not to be";"or";1;0;0;"@@@")</input> returns the string "not to be", taking
after the delimiter "or".</paragraph>
+<paragraph role="paragraph" id="par_id971747068062071"><input>=TEXTAFTER("To
be or not to be";"question";1;0;0;"@@@")</input> returns the text "@@@" because
the delimiter "question" is not in the source text.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#25.8"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640873986703"
localize="false"><literal>COM.MICROSOFT.TEXTAFTER</literal></paragraph>
+<section id="relatedtopics">
+ <tip id="par_id761677014445916"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/TEXTAFTER";>TEXTAFTER
wiki page</link>.</tip>
+ <paragraph role="paragraph" id="par_id1001746970893891"
localize="false"><embedvar href="text/scalc/01/func_textjoin.xhp#textjoinfunct"
markup="ignore"/></paragraph>
+ <paragraph role="paragraph" id="par_id851747068377843"
localize="false"><embedvar
href="text/scalc/01/func_textsplit.xhp#textsplitfunct"
markup="ignore"/></paragraph>
+ <paragraph role="paragraph" id="par_id81747069728010"
localize="false"><embedvar href="text/scalc/01/func_textbefore.xhp#h1"
markup="ignore"/></paragraph>
+</section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/func_textbefore.xhp
b/source/text/scalc/01/func_textbefore.xhp
index b930215195..e518f8043c 100644
--- a/source/text/scalc/01/func_textbefore.xhp
+++ b/source/text/scalc/01/func_textbefore.xhp
@@ -25,7 +25,7 @@
<paragraph id="par_id381747059635191" role="paragraph">Returns the text
that occurs before a given substring or delimiter.</paragraph>
</section>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph role="code" id="par_id541556228253979">TEXTBEFORE(Text [; Delimiter
[; Instance Number [; Match Mode [; Match End [; If Not Found ]]]]])</paragraph>
+<paragraph role="code" id="par_id541556228253979">TEXTBEFORE( Text [;
Delimiter [; Instance Number [; Match Mode [; Match End [; If Not Found
]]]]])</paragraph>
<paragraph role="paragraph" id="par_id91747066169381"><emph>Text</emph>: the
original text.</paragraph>
<paragraph role="paragraph" id="par_id221747066174430"><emph>Delimiter</emph>:
(optional) the delimiter. Multiple delimiters can be supplied.</paragraph>
<paragraph role="paragraph" id="par_id821747066179393"><emph>Instance
Number</emph>: (optional) the instance of the delimiter before which to extract
text. The default is 1. A negative number starts searching from the
end.</paragraph>
@@ -44,6 +44,7 @@
<tip id="par_id761677014445916"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/TEXTBEFORE";>TEXTBEFORE
wiki page</link>.</tip>
<paragraph role="paragraph" id="par_id1001746970893891"
localize="false"><embedvar href="text/scalc/01/func_textjoin.xhp#textjoinfunct"
markup="ignore"/></paragraph>
<paragraph role="paragraph" id="par_id851747068377843"
localize="false"><embedvar
href="text/scalc/01/func_textsplit.xhp#textsplitfunct"
markup="ignore"/></paragraph>
+ <paragraph role="paragraph" id="par_id81747069728010"
localize="false"><embedvar href="text/scalc/01/func_textafter.xhp#h1"
markup="ignore"/></paragraph>
</section>
</body>
</helpdocument>
commit 8f83b7a9d6db0adb69580d06fd4fd7bb69e69403
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Mon May 12 13:59:15 2025 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Tue May 13 12:58:04 2025 +0200
tdf#150864 Help page for TEXTBEFORE function
+ Fix syntax for TEXSPLIT
Change-Id: I0c0ce6e3ccdc23e23c98277dcbf9272af40921e0
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/185229
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 31045b078c..8511fa7d5f 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -314,6 +314,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_sumif \
helpcontent2/source/text/scalc/01/func_sumifs \
helpcontent2/source/text/scalc/01/func_switch \
+ helpcontent2/source/text/scalc/01/func_textbefore \
helpcontent2/source/text/scalc/01/func_textjoin \
helpcontent2/source/text/scalc/01/func_textsplit \
helpcontent2/source/text/scalc/01/func_time \
diff --git a/source/text/scalc/01/func_textbefore.xhp
b/source/text/scalc/01/func_textbefore.xhp
new file mode 100644
index 0000000000..b930215195
--- /dev/null
+++ b/source/text/scalc/01/func_textbefore.xhp
@@ -0,0 +1,49 @@
+<?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="text/scalc/01/func_textbefore.xhp" indexer="include"
status="PUBLISH">
+ <title id="tit">TEXTBEFORE function</title>
+ <filename>/text/scalc/01/func_textbefore.xhp</filename>
+ </topic>
+</meta>
+<body>
+<bookmark id="bm_id921747059635186" branch="hid/SC_HID_FUNC_TEXTBEFORE_MS"
localize="false"/>
+<bookmark branch="index" id="bm_id581556228060864">
+<bookmark_value>TEXTBEFORE function</bookmark_value>
+</bookmark>
+<section id="section identification">
+ <h1 id="hd_id451747059635188"><variable id="h1"><link
href="text/scalc/01/func_textbefore.xhp">TEXTBEFORE</link></variable></h1>
+ <paragraph id="par_id381747059635191" role="paragraph">Returns the text
that occurs before a given substring or delimiter.</paragraph>
+</section>
+<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
+<paragraph role="code" id="par_id541556228253979">TEXTBEFORE(Text [; Delimiter
[; Instance Number [; Match Mode [; Match End [; If Not Found ]]]]])</paragraph>
+<paragraph role="paragraph" id="par_id91747066169381"><emph>Text</emph>: the
original text.</paragraph>
+<paragraph role="paragraph" id="par_id221747066174430"><emph>Delimiter</emph>:
(optional) the delimiter. Multiple delimiters can be supplied.</paragraph>
+<paragraph role="paragraph" id="par_id821747066179393"><emph>Instance
Number</emph>: (optional) the instance of the delimiter before which to extract
text. The default is 1. A negative number starts searching from the
end.</paragraph>
+<paragraph role="paragraph" id="par_id121747066183422"><emph>Match
Mode</emph>: (optional) set to 1 to perform a case-insensitive match. The
default is 0.</paragraph>
+<paragraph role="paragraph" id="par_id201747066188182"><emph>Match End</emph>:
(optional) set to 1 to treat the end of text as a delimiter. The default is
0.</paragraph>
+<paragraph role="paragraph" id="par_id701747066192253"><emph>If Not
Found</emph>: (optional) the value returned if no match is found. 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_id21747067698384"><input>=TEXTBEFORE("To
be or not to be";"be";2;0;0;"@@@")</input> returns the string "To be or not
to", taking up to the second instance of the delimiter "be".</paragraph>
+<paragraph role="paragraph" id="par_id971747068062071"><input>=TEXTBEFORE("To
be or not to be";"question";1;0;0;"@@@")</input> returns the text "@@@" because
the delimiter "question" is not in the source text.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#25.8"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640873986703"
localize="false"><literal>COM.MICROSOFT.TEXTBEFORE</literal></paragraph>
+<section id="relatedtopics">
+ <tip id="par_id761677014445916"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/TEXTBEFORE";>TEXTBEFORE
wiki page</link>.</tip>
+ <paragraph role="paragraph" id="par_id1001746970893891"
localize="false"><embedvar href="text/scalc/01/func_textjoin.xhp#textjoinfunct"
markup="ignore"/></paragraph>
+ <paragraph role="paragraph" id="par_id851747068377843"
localize="false"><embedvar
href="text/scalc/01/func_textsplit.xhp#textsplitfunct"
markup="ignore"/></paragraph>
+</section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/func_textsplit.xhp
b/source/text/scalc/01/func_textsplit.xhp
index 535c7b694b..13edbc1be2 100644
--- a/source/text/scalc/01/func_textsplit.xhp
+++ b/source/text/scalc/01/func_textsplit.xhp
@@ -26,7 +26,7 @@
</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="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>:
(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>
@@ -84,7 +84,7 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id341640873986703"
localize="false"><literal>COM.MICROSOFT.TEXTSPLIT</literal></paragraph>
<section id="relatedtopics">
- <tip id="par_id761677014445916"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/TEXTJOIN";>TEXTSPLIT
wiki page</link>.</tip>
+ <tip id="par_id761677014445916"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/TEXTSPLIT";>TEXTSPLIT
wiki page</link>.</tip>
<paragraph role="paragraph" id="par_id1001746970893891"
localize="false"><embedvar href="text/scalc/01/func_textjoin.xhp#textjoinfunct"
markup="ignore"/></paragraph>
</section>
</body>
