source/text/scalc/01/func_textafter.xhp | 8 ++++---- source/text/scalc/01/func_textbefore.xhp | 8 ++++---- 2 files changed, 8 insertions(+), 8 deletions(-)
New commits: commit e8d729c0fe8761998e2f5e6caf704b1c63055af9 Author: Olivier Hallot <[email protected]> AuthorDate: Mon Jun 15 10:17:28 2026 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Mon Jun 15 17:09:18 2026 +0200 Add precision on TXTAFTER and TEXTBEFORE Change-Id: I1358b6e2119cd9aa8b1c27f0be2643479738b96c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/206656 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/scalc/01/func_textafter.xhp b/source/text/scalc/01/func_textafter.xhp index 10f11ba1b9..e8fcd70d51 100644 --- a/source/text/scalc/01/func_textafter.xhp +++ b/source/text/scalc/01/func_textafter.xhp @@ -22,16 +22,16 @@ </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> + <description id="par_id381747059635191">Returns the text that occurs after the end of a given instance of a delimiter substring.</description> </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_id221747066174430"><emph>Delimiter</emph>: (optional) the delimiter. Multiple delimiters can be supplied. If omitted or supplied as an empty string, then returns the error <emph>#N/A</emph> or the value expressed by <emph>If Not Found</emph>.</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. Value 0 returns the error <emph>#N/A</emph>.</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> +<paragraph role="paragraph" id="par_id701747066192253"><emph>If Not Found</emph>: (optional) the value returned if no match is found. The default is <emph>#N/A</emph>.</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> diff --git a/source/text/scalc/01/func_textbefore.xhp b/source/text/scalc/01/func_textbefore.xhp index 57dd76f50c..0bf2dd448a 100644 --- a/source/text/scalc/01/func_textbefore.xhp +++ b/source/text/scalc/01/func_textbefore.xhp @@ -22,16 +22,16 @@ </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> + <description id="par_id381747059635191">Returns the text that occurs before the start of given instance of a delimiter substring.</description> </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_id221747066174430"><emph>Delimiter</emph>: (optional) the delimiter. Multiple delimiters can be supplied. If omitted or supplied as an empty string, then returns the error <emph>#N/A</emph> or the value expressed by <emph>If Not Found</emph>.</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. Value 0 returns the error <emph>#N/A</emph></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> +<paragraph role="paragraph" id="par_id701747066192253"><emph>If Not Found</emph>: (optional) the value returned if no match is found. The default is <emph>#N/A</emph>.</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>
