AllLangHelp_scalc.mk | 1
source/text/scalc/01/func_textafter.xhp | 50 +++++++++++++++++++++++++++++++
source/text/scalc/01/func_textbefore.xhp | 3 +
3 files changed, 53 insertions(+), 1 deletion(-)
New commits:
commit 147847ee1ea9f90645c44e1bb8444ad53545bc0c
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Mon May 12 14:18:47 2025 -0300
Commit: Aron Budea <aron.bu...@collabora.com>
CommitDate: Tue Aug 26 22:13:56 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>
(cherry picked from commit 68f45944fe1f7228736f82e41cddb056e165f7cb)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/190253
Tested-by: Aron Budea <aron.bu...@collabora.com>
Reviewed-by: Aron Budea <aron.bu...@collabora.com>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index caa87f39dd..2bef9cf1da 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -313,6 +313,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>
