AllLangHelp_scalc.mk | 1
source/text/scalc/01/func_textbefore.xhp | 49 +++++++++++++++++++++++++++++++
source/text/scalc/01/func_textsplit.xhp | 19 ++++++------
3 files changed, 60 insertions(+), 9 deletions(-)
New commits:
commit b0d094a7fdeee8fe342188adee0449a0925b273b
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Mon May 12 13:59:15 2025 -0300
Commit: Aron Budea <aron.bu...@collabora.com>
CommitDate: Tue Aug 26 22:13:47 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>
(cherry picked from commit 8f83b7a9d6db0adb69580d06fd4fd7bb69e69403)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/190252
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 db77c7296f..caa87f39dd 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_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>
commit 8ba57bb0f5936d2d17d8ab74c6cc8893287e628d
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sun May 11 11:36:47 2025 -0300
Commit: Aron Budea <aron.bu...@collabora.com>
CommitDate: Tue Aug 26 22:13:37 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>
(cherry picked from commit a849732e3fca989e387de7cd2272c53a792d5ba3)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/190251
Tested-by: Aron Budea <aron.bu...@collabora.com>
Reviewed-by: Aron Budea <aron.bu...@collabora.com>
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>
