source/text/scalc/01/func_findb.xhp | 17 ++++++----------- source/text/scalc/01/func_leftb.xhp | 4 ++++ source/text/scalc/01/func_lenb.xhp | 4 ++++ source/text/scalc/01/func_midb.xhp | 4 ++++ source/text/scalc/01/func_replaceb.xhp | 21 ++++++++++++--------- source/text/scalc/01/func_rightb.xhp | 4 ++++ source/text/scalc/01/func_searchb.xhp | 17 ++++++----------- 7 files changed, 40 insertions(+), 31 deletions(-)
New commits: commit 076e328920c3323a95e35a5ef7c0af0fa91b8214 Author: Olivier Hallot <[email protected]> AuthorDate: Mon Feb 9 15:39:18 2026 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Mon Feb 9 19:43:21 2026 +0100 Fix bad links + some refactor Change-Id: I630c38727cb4ff0f8cd285444d1bf9288aab2d75 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/199008 Reviewed-by: Olivier Hallot <[email protected]> Tested-by: Jenkins diff --git a/source/text/scalc/01/func_findb.xhp b/source/text/scalc/01/func_findb.xhp index eb74621a38..e421cc3cdd 100644 --- a/source/text/scalc/01/func_findb.xhp +++ b/source/text/scalc/01/func_findb.xhp @@ -11,19 +11,19 @@ <meta> <topic id="functionfindb" indexer="include" status="PUBLISH"> - <title id="tit" xml-lang="en-US">FINDB Function</title> + <title id="tit">FINDB Function</title> <filename>/text/scalc/01/func_findb.xhp</filename> </topic> </meta> <body> <section id="findbh1"> - <bookmark id="bm_id461573508637964" xml-lang="en-US" branch="hid/SC_HID_FUNC_FINDB" localize="false"/> - <bookmark xml-lang="en-US" branch="index" id="bm_id141573508995071"> + <bookmark id="bm_id461573508637964" branch="hid/SC_HID_FUNC_FINDB" localize="false"/> + <bookmark branch="index" id="bm_id141573508995071"> <bookmark_value>FINDB Function</bookmark_value> <bookmark_value>find text;FINDB Function</bookmark_value> </bookmark> <h1 id="hd_id771573508637966"><variable id="findb"><link href="text/scalc/01/func_findb.xhp">FINDB</link></variable></h1> - <paragraph id="par_id831573508637970" role="paragraph" xml-lang="en-US"><variable id="variable name"><ahelp hid=".">Returns the starting position of a given text, using byte positions. FINDB is case sensitive.</ahelp></variable></paragraph> + <paragraph id="par_id831573508637970" role="paragraph"><variable id="variable name"><ahelp hid=".">Returns the starting position of a given text, using byte positions. FINDB is case sensitive.</ahelp></variable></paragraph> </section> <embed href="text/scalc/00/avail_release.xhp#6.0"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> @@ -34,13 +34,8 @@ <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id481573517830373"><input>=FINDB("ａ"; "LibreOffice Ｃａｌｃ")</input> returns 15. The <emph>Find Text</emph> argument is a text string that comprises a full-width, double-byte "a" character, while the <emph>Text</emph> argument comprises 12 single-byte characters followed by four full-width, double-byte characters.</paragraph> <section id="relatedtopics"> - <tip id="par_id491677016507189"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/FINDB";>FINDB wiki page</link>.</tip> - <paragraph role="paragraph" localize="false" id="par_id961573510093188"><embedvar href="text/scalc/01/func_replaceb.xhp#replaceb" markup="ignore"/></paragraph> - <paragraph role="paragraph" localize="false" id="par_id831573510098350"><embedvar href="text/scalc/01/func_searchb.xhp#searchb" markup="ignore"/></paragraph> - <paragraph role="paragraph" localize="false" id="par_id251573510740369"><embedvar href="text/scalc/01/04060110.xhp#lenbvar" markup="ignore"/></paragraph> - <paragraph role="paragraph" localize="false" id="par_id121573511036023"><embedvar href="text/scalc/01/04060110.xhp#leftbvar" markup="ignore"/></paragraph> - <paragraph role="paragraph" localize="false" id="par_id591573511169353"><embedvar href="text/scalc/01/04060110.xhp#rightbvar" markup="ignore"/></paragraph> - <paragraph role="paragraph" localize="false" id="par_id381573511326662"><embedvar href="text/scalc/01/04060110.xhp#midbvar" markup="ignore"/></paragraph> + <tip id="par_id71677014897959"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/FINDB";>FINDB wiki page</link>.</tip> + <embed href="text/scalc/01/func_replaceb.xhp#other_b_functions"/> </section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_leftb.xhp b/source/text/scalc/01/func_leftb.xhp index 674d15752a..44fad5f328 100644 --- a/source/text/scalc/01/func_leftb.xhp +++ b/source/text/scalc/01/func_leftb.xhp @@ -37,5 +37,9 @@ <paragraph id="par_id2949161" role="paragraph"><item type="input">=LEFTB("中国";3)</item> returns "中 " (3 bytes constitute one DBCS character and a half; the last character returned is therefore a space character).</paragraph> <paragraph id="par_id2949171" role="paragraph"><item type="input">=LEFTB("中国";4)</item> returns "中国" (4 bytes constitute two complete DBCS characters).</paragraph> <paragraph id="par_id2949181" role="paragraph"><item type="input">=LEFTB("office";3)</item> returns "off" (3 non-DBCS characters each consisting of 1 byte).</paragraph> + <section id="relatedtopics"> + <tip id="par_id71677014897959"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/LEFTB";>LEFTB wiki page</link>.</tip> + <embed href="text/scalc/01/func_replaceb.xhp#other_b_functions"/> + </section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_lenb.xhp b/source/text/scalc/01/func_lenb.xhp index ebf0a71c84..15f7146060 100644 --- a/source/text/scalc/01/func_lenb.xhp +++ b/source/text/scalc/01/func_lenb.xhp @@ -37,5 +37,9 @@ <paragraph id="par_id2956038" role="paragraph"><item type="input">LENB("office")</item> returns 6 (6 non-DBCS characters each consisting of 1 byte).</paragraph> <paragraph id="par_id2956008" role="paragraph"> <item type="input">=LENB("Good Afternoon")</item> returns 14.</paragraph> <paragraph id="par_id2954300" role="paragraph"> <item type="input">=LENB(12345.67)</item> returns 8.</paragraph> + <section id="relatedtopics"> + <tip id="par_id71677014897959"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/LENB";>LENB wiki page</link>.</tip> + <embed href="text/scalc/01/func_replaceb.xhp#other_b_functions"/> + </section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_midb.xhp b/source/text/scalc/01/func_midb.xhp index 0e9b97ff9b..59992a407f 100644 --- a/source/text/scalc/01/func_midb.xhp +++ b/source/text/scalc/01/func_midb.xhp @@ -45,5 +45,9 @@ <paragraph id="par_id2958497" role="paragraph"><item type="input">=MIDB("中国";3;1)</item> returns " " (byte position 3 is at the beginning of a character in a DBCS string, but 1 byte is only half a DBCS character and a space character is therefore returned instead).</paragraph> <paragraph id="par_id2958507" role="paragraph"><item type="input">=MIDB("中国";3;2)</item> returns "国" (byte position 3 is at the beginning of a character in a DBCS string, and 2 bytes constitute one DBCS character).</paragraph> <paragraph id="par_id2958517" role="paragraph"><item type="input">=MIDB("office";2;3)</item> returns "ffi" (byte position 2 is at the beginning of a character in a non-DBCS string, and 3 bytes of a non-DBCS string constitute 3 characters).</paragraph> + <section id="relatedtopics"> + <tip id="par_id71677014897959"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/MIDB";>MIDB wiki page</link>.</tip> + <embed href="text/scalc/01/func_replaceb.xhp#other_b_functions"/> + </section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_replaceb.xhp b/source/text/scalc/01/func_replaceb.xhp index d9c61cf31b..125ad41aeb 100644 --- a/source/text/scalc/01/func_replaceb.xhp +++ b/source/text/scalc/01/func_replaceb.xhp @@ -11,23 +11,23 @@ <meta> <topic id="functionreplaceb" indexer="include" status="PUBLISH"> - <title id="tit" xml-lang="en-US">REPLACEB Function</title> + <title id="tit">REPLACEB Function</title> <filename>/text/scalc/01/func_replaceb.xhp</filename> </topic> </meta> <body> <section id="replacebh1"> - <bookmark id="bm_id461573508637964" xml-lang="en-US" branch="hid/SC_HID_FUNC_REPLACEB" localize="false"/> - <bookmark xml-lang="en-US" branch="index" id="bm_id141573508995071"> + <bookmark id="bm_id461573508637964" branch="hid/SC_HID_FUNC_REPLACEB" localize="false"/> + <bookmark branch="index" id="bm_id141573508995071"> <bookmark_value>REPLACEB Function</bookmark_value> <bookmark_value>replace text;REPLACEB Function</bookmark_value> </bookmark> <h1 id="hd_id771573508637966"><variable id="replaceb"><link href="text/scalc/01/func_replaceb.xhp">REPLACEB</link></variable></h1> - <paragraph id="par_id831573508637970" role="paragraph" xml-lang="en-US"><variable id="variable name"><ahelp hid=".">Returns text where an old text is replaced with a new text, using byte positions.</ahelp></variable></paragraph> + <paragraph id="par_id831573508637970" role="paragraph"><variable id="variable name"><ahelp hid=".">Returns text where an old text is replaced with a new text, using byte positions.</ahelp></variable></paragraph> </section> <embed href="text/scalc/00/avail_release.xhp#6.0"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> - <paragraph role="code" id="par_id701542231253817" xml-lang="en-US">REPLACEB( Text ; Position ; Length ; NewText )</paragraph> + <paragraph role="code" id="par_id701542231253817">REPLACEB( Text ; Position ; Length ; NewText )</paragraph> <paragraph role="paragraph" id="par_id331573510857418"><emph>Text</emph>: A text expression or reference to a cell containing a text expression in which the bytes are to be replaced.</paragraph> <paragraph role="paragraph" id="par_id431573510862075"><emph>Position</emph>: the byte position from which text is to be replaced. </paragraph> <paragraph role="paragraph" id="par_id481573510866260"><emph>Length</emph>: the number of bytes to be replaced.</paragraph> @@ -38,12 +38,15 @@ <section id="relatedtopics"> <tip id="par_id71677014897959"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPLACEB";>REPLACEB wiki page</link>.</tip> + <section id="other_b_functions"> <paragraph role="paragraph" localize="false" id="par_id171573510071709"><embedvar href="text/scalc/01/func_findb.xhp#findb" markup="ignore"/></paragraph> <paragraph role="paragraph" localize="false" id="par_id831573510098350"><embedvar href="text/scalc/01/func_searchb.xhp#searchb" markup="ignore"/></paragraph> - <paragraph role="paragraph" localize="false" id="par_id251573510740369"><embedvar href="text/scalc/01/04060110.xhp#lenbvar" markup="ignore"/></paragraph> - <paragraph role="paragraph" localize="false" id="par_id121573511036023"><embedvar href="text/scalc/01/04060110.xhp#leftbvar" markup="ignore"/></paragraph> - <paragraph role="paragraph" localize="false" id="par_id591573511169353"><embedvar href="text/scalc/01/04060110.xhp#rightbvar" markup="ignore"/></paragraph> - <paragraph role="paragraph" localize="false" id="par_id381573511326662"><embedvar href="text/scalc/01/04060110.xhp#midbvar" markup="ignore"/></paragraph> + <paragraph role="paragraph" localize="false" id="par_id251573510740369"><embedvar href="text/scalc/01/func_lenb.xhp#lenbvar" markup="ignore"/></paragraph> + <paragraph role="paragraph" localize="false" id="par_id121573511036023"><embedvar href="text/scalc/01/func_leftb.xhp#leftbvar" markup="ignore"/></paragraph> + <paragraph role="paragraph" localize="false" id="par_id591573511169353"><embedvar href="text/scalc/01/func_rightb.xhp#rightbvar" markup="ignore"/></paragraph> + <paragraph role="paragraph" localize="false" id="par_id381573511326662"><embedvar href="text/scalc/01/func_midb.xhp#midbvar" markup="ignore"/></paragraph> + <paragraph role="paragraph" id="par_id41770661484072" localize="false"><embedvar href="text/scalc/01/func_replaceb.xhp#replaceb" markup="ignore"/></paragraph> + </section> </section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_rightb.xhp b/source/text/scalc/01/func_rightb.xhp index b297ce50bd..c886655998 100644 --- a/source/text/scalc/01/func_rightb.xhp +++ b/source/text/scalc/01/func_rightb.xhp @@ -37,5 +37,9 @@ <paragraph id="par_id2951152" role="paragraph"><item type="input">RIGHTB("中国";3)</item> returns " 国" (3 bytes constitute one half DBCS character and one whole DBCS character; a space is returned for the first half).</paragraph> <paragraph id="par_id2951162" role="paragraph"><item type="input">RIGHTB("中国";4)</item> returns "中国" (4 bytes constitute two complete DBCS characters).</paragraph> <paragraph id="par_id2951172" role="paragraph"><item type="input">RIGHTB("office";3)</item> returns "ice" (3 non-DBCS characters each consisting of 1 byte).</paragraph> + <section id="relatedtopics"> + <tip id="par_id71677014897959"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/RIGHTB";>RIGHTB wiki page</link>.</tip> + <embed href="text/scalc/01/func_replaceb.xhp#other_b_functions"/> + </section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_searchb.xhp b/source/text/scalc/01/func_searchb.xhp index 482ad1013b..5d77779b14 100644 --- a/source/text/scalc/01/func_searchb.xhp +++ b/source/text/scalc/01/func_searchb.xhp @@ -11,19 +11,19 @@ <meta> <topic id="functionsearchb" indexer="include" status="PUBLISH"> - <title id="tit" xml-lang="en-US">SEARCHB Function</title> + <title id="tit">SEARCHB Function</title> <filename>/text/scalc/01/func_searchb.xhp</filename> </topic> </meta> <body> <section id="searchbh1"> - <bookmark id="bm_id461573508637964" xml-lang="en-US" branch="hid/SC_HID_FUNC_SEARCHB" localize="false"/> - <bookmark xml-lang="en-US" branch="index" id="bm_id141573508995071"> + <bookmark id="bm_id461573508637964" branch="hid/SC_HID_FUNC_SEARCHB" localize="false"/> + <bookmark branch="index" id="bm_id141573508995071"> <bookmark_value>SEARCHB Function</bookmark_value> <bookmark_value>search text;SEARCHB Function</bookmark_value> </bookmark> <h1 id="hd_id771573508637966"><variable id="searchb"><link href="text/scalc/01/func_searchb.xhp">SEARCHB</link></variable></h1> - <paragraph id="par_id831573508637970" role="paragraph" xml-lang="en-US"><variable id="variable name"><ahelp hid=".">Returns the starting position of a given text, using byte positions (not case sensitive).</ahelp></variable></paragraph> + <paragraph id="par_id831573508637970" role="paragraph"><variable id="variable name"><ahelp hid=".">Returns the starting position of a given text, using byte positions (not case sensitive).</ahelp></variable></paragraph> </section> <embed href="text/scalc/00/avail_release.xhp#6.0"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> @@ -35,13 +35,8 @@ <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id561573517310749"><input>=SEARCHB("ᄫᄬ";"ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ";17)</input> returns 20.</paragraph> <section id="relatedtopics"> - <tip id="par_id531677014781664"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/SEARCHB";>SEARCHB wiki page</link>.</tip> - <paragraph role="paragraph" localize="false" id="par_id171573510071709"><embedvar href="text/scalc/01/func_findb.xhp#findb" markup="ignore"/></paragraph> - <paragraph role="paragraph" localize="false" id="par_id961573510093188"><embedvar href="text/scalc/01/func_replaceb.xhp#replaceb" markup="ignore"/></paragraph> - <paragraph role="paragraph" localize="false" id="par_id251573510740369"><embedvar href="text/scalc/01/04060110.xhp#lenbvar" markup="ignore"/></paragraph> - <paragraph role="paragraph" localize="false" id="par_id121573511036023"><embedvar href="text/scalc/01/04060110.xhp#leftbvar" markup="ignore"/></paragraph> - <paragraph role="paragraph" localize="false" id="par_id591573511169353"><embedvar href="text/scalc/01/04060110.xhp#rightbvar" markup="ignore"/></paragraph> - <paragraph role="paragraph" localize="false" id="par_id381573511326662"><embedvar href="text/scalc/01/04060110.xhp#midbvar" markup="ignore"/></paragraph> + <tip id="par_id71677014897959"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/SEARCHB";>SEARCHB wiki page</link>.</tip> + <embed href="text/scalc/01/func_replaceb.xhp#other_b_functions"/> </section> </body> </helpdocument>
