From 1a28d0647ccd790bac0c1dbdad6eda44a5c8eaa1 Mon Sep 17 00:00:00 2001
From: Olivier Hallot <olivier.hallot@libreoffice.org>
Date: Mon, 11 Nov 2019 21:58:34 -0300
Subject: Add FINDB, SEARCHB and REPLACEB Help pages

Change-Id: Ie8a7c5762f41484d36837008226cc446584e3110
Reviewed-on: https://gerrit.libreoffice.org/82481
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
---
 AllLangHelp_scalc.mk                   |  3 +++
 source/text/scalc/01/04060110.xhp      |  8 +++---
 source/text/scalc/01/func_findb.xhp    | 45 +++++++++++++++++++++++++++++++
 source/text/scalc/01/func_replaceb.xhp | 48 ++++++++++++++++++++++++++++++++++
 source/text/scalc/01/func_searchb.xhp  | 46 ++++++++++++++++++++++++++++++++
 5 files changed, 146 insertions(+), 4 deletions(-)
 create mode 100644 source/text/scalc/01/func_findb.xhp
 create mode 100644 source/text/scalc/01/func_replaceb.xhp
 create mode 100644 source/text/scalc/01/func_searchb.xhp

diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 2fcc39a4ec..538b4ecadb 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -201,6 +201,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
     helpcontent2/source/text/scalc/01/func_edate \
     helpcontent2/source/text/scalc/01/func_eomonth \
     helpcontent2/source/text/scalc/01/func_error_type \
+    helpcontent2/source/text/scalc/01/func_findb \
     helpcontent2/source/text/scalc/01/func_forecastetsadd \
     helpcontent2/source/text/scalc/01/func_forecastetsmult \
     helpcontent2/source/text/scalc/01/func_forecastetsstatadd \
@@ -236,9 +237,11 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
     helpcontent2/source/text/scalc/01/func_now \
     helpcontent2/source/text/scalc/01/func_rawsubtract \
     helpcontent2/source/text/scalc/01/func_regex \
+    helpcontent2/source/text/scalc/01/func_replaceb \
     helpcontent2/source/text/scalc/01/func_roundsig \
     helpcontent2/source/text/scalc/01/func_second \
     helpcontent2/source/text/scalc/01/func_skewp \
+    helpcontent2/source/text/scalc/01/func_searchb \
     helpcontent2/source/text/scalc/01/func_sumifs \
     helpcontent2/source/text/scalc/01/func_switch \
     helpcontent2/source/text/scalc/01/func_textjoin \
diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp
index 664d238859..5e24c67a82 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -349,7 +349,7 @@
 
 <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LEFTB" id="bm_id2954645" localize="false"/>
 
-<h2 id="hd_id2947083">LEFTB</h2>
+<h2 id="hd_id2947083"><variable id="leftbvar"><link href="text/scalc/01/04060110.xhp#leftb" name="LEFTB">LEFTB</link></variable></h2>
 <paragraph id="par_id2953622" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_LEFTB">Returns the first characters of a DBCS text.</ahelp></paragraph>
 <embed href="text/scalc/00/avail_release.xhp#4.2"/>
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -391,7 +391,7 @@
 
 <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LENB" id="bm_id2954050" localize="false"/>
 
-<h2 id="hd_id2956110">LENB</h2>
+<h2 id="hd_id2956110"><variable id="lenbvar"><link href="text/scalc/01/04060110.xhp#lenb" name="LENB">LENB</link></variable></h2>
 <paragraph id="par_id2950147" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_LENB">For double-byte character set (DBCS) languages, returns the number of bytes used to represent the characters in a text string.</ahelp></paragraph>
 <embed href="text/scalc/00/avail_release.xhp#4.2"/>
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -451,7 +451,7 @@
 
 <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MIDB" id="bm_id2955392" localize="false"/>
 
-<h2 id="hd_id2954589">MIDB</h2>
+<h2 id="hd_id2954589"><variable id="midbvar"><link href="text/scalc/01/04060110.xhp#midb" name="MIDB">MIDB</link></variable></h2>
 <paragraph id="par_id2954938" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_MIDB">Returns a text string of a DBCS text. The parameters specify the starting position and the number of characters.</ahelp></paragraph>
 <embed href="text/scalc/00/avail_release.xhp#4.2"/>
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -564,7 +564,7 @@
 
 <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RIGHTB" id="bm_id2954602" localize="false"/>
 
-<h2 id="hd_id2949805">RIGHTB</h2>
+<h2 id="hd_id2949805"><variable id="rightbvar"><link href="text/scalc/01/04060110.xhp#rightb" name="RIGHTB">RIGHTB</link></variable></h2>
 <paragraph id="par_id2945375" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_RIGHTB">Returns the last character or characters of a text with double bytes characters sets (DBCS).</ahelp></paragraph>
 <embed href="text/scalc/00/avail_release.xhp#4.2"/>
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
diff --git a/source/text/scalc/01/func_findb.xhp b/source/text/scalc/01/func_findb.xhp
new file mode 100644
index 0000000000..0ab9ead47d
--- /dev/null
+++ b/source/text/scalc/01/func_findb.xhp
@@ -0,0 +1,45 @@
+<?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="functionfindb" indexer="include" status="PUBLISH">
+            <title id="tit" xml-lang="en-US">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_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" name="findb">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>
+    </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_id221573517641172">FINDB( Find Text ; Text ; Position )</paragraph>
+    <paragraph role="paragraph" id="par_id241573517292388"><emph>Find Text</emph>: The text or text expression to be found.</paragraph>
+    <paragraph role="paragraph" id="par_id991573517299918"><emph>Text</emph>: the text in which the search is to be made.</paragraph>
+    <paragraph role="paragraph" id="par_id521573517305077"><emph>Position</emph>: The position in the text where the search starts.</paragraph>
+    <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
+    <paragraph role="paragraph" id="par_id481573517830373"><input>=FINDB("ᄫᄬ";"ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ";17)</input> returns 19.</paragraph>
+    <section id="relatedtopics">
+        <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>
+    </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/func_replaceb.xhp b/source/text/scalc/01/func_replaceb.xhp
new file mode 100644
index 0000000000..52966391cb
--- /dev/null
+++ b/source/text/scalc/01/func_replaceb.xhp
@@ -0,0 +1,48 @@
+<?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="functionreplaceb" indexer="include" status="PUBLISH">
+            <title id="tit" xml-lang="en-US">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_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" name="replaceb">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>
+    </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="paragraph" id="par_id331573510857418"><emph>Text</emph>: A text expression or reference to a cell containing a text expression in which the characters are to be replaced.</paragraph>
+    <paragraph role="paragraph" id="par_id431573510862075"><emph>Position</emph>: the character position from which text is to be replaced. </paragraph>
+    <paragraph role="paragraph" id="par_id481573510866260"><emph>Length</emph>: the number of characters to be replaced.</paragraph>
+    <paragraph role="paragraph" id="par_id911573510871412"><emph>NewText</emph>: the text to be inserted.</paragraph>
+    <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
+
+    <paragraph role="paragraph" id="par_id431573515742206"><input>=REPLACEB("ᄩᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ";4;1;"ab")</input> returns "ᄩ abᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ" .</paragraph>
+
+    <section id="relatedtopics">
+        <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>
+    </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/func_searchb.xhp b/source/text/scalc/01/func_searchb.xhp
new file mode 100644
index 0000000000..201a007696
--- /dev/null
+++ b/source/text/scalc/01/func_searchb.xhp
@@ -0,0 +1,46 @@
+<?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="functionsearchb" indexer="include" status="PUBLISH">
+            <title id="tit" xml-lang="en-US">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_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" name="searchb">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>
+    </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_id531573516878780">SEARCHB( Find text ; Text ; Position)</paragraph>
+    <paragraph role="paragraph" id="par_id241573517292388"><emph>Find Text</emph>: The text or text expression to be found.</paragraph>
+    <paragraph role="paragraph" id="par_id991573517299918"><emph>Text</emph>: the text in which the search is to be made.</paragraph>
+    <paragraph role="paragraph" id="par_id521573517305077"><emph>Position</emph>: The position in the text where the search starts.</paragraph>
+
+    <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">
+        <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>
+    </section>
+</body>
+</helpdocument>
-- 
cgit