tdf#143846 split LEFTB LENB MIDB RIGHTB

Change-Id: I57be1c7ea1642ef84798fadc6dd204bbac4c994e
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/176069
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>

7 files changed, 222 insertions, 113 deletions

diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 62d82eb3f4..b22994f520 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -255,6 +255,11 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
     helpcontent2/source/text/scalc/01/func_imtan \
     helpcontent2/source/text/scalc/01/func_isoweeknum \
     helpcontent2/source/text/scalc/01/func_jis \
+    helpcontent2/source/text/scalc/01/func_leftb \
+    helpcontent2/source/text/scalc/01/func_lenb \
+    helpcontent2/source/text/scalc/01/func_mid \
+    helpcontent2/source/text/scalc/01/func_midb \
+    helpcontent2/source/text/scalc/01/func_rightb \
     helpcontent2/source/text/scalc/01/func_let \
     helpcontent2/source/text/scalc/01/func_maxifs \
     helpcontent2/source/text/scalc/01/func_minifs \
diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp
index fb03ee3956..5fefe476c3 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -122,104 +122,17 @@
 
 <section id="left"><embed href="text/scalc/01/func_left.xhp#func_left"/></section>
 
-<section id="leftb">
-<bookmark branch="index" id="bm_id2947083">
-  <bookmark_value>LEFTB function</bookmark_value>
-</bookmark>
-
-<bookmark branch="hid/SC_HID_FUNC_LEFTB" id="bm_id2954645" localize="false"/>
-
-<h2 id="hd_id2947083"><variable id="leftbvar"><link href="text/scalc/01/04060110.xhp#leftb">LEFTB</link></variable></h2>
-<paragraph id="par_id2953622" role="paragraph"><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"/>
-<paragraph id="par_id2946786" role="code">LEFTB("Text" [; Number_bytes])</paragraph>
-<paragraph id="par_id2947274" role="paragraph"><emph>Text</emph> is the text where the initial partial words are to be determined.</paragraph>
-<paragraph id="par_id2953152" role="paragraph"><emph>Number_bytes</emph> (optional) specifies the number of characters you want LEFTB to extract, based on bytes. If this parameter is not defined, one character is returned.</paragraph>
-
-<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id2949141" role="paragraph"><item type="input">=LEFTB("中国";1)</item> returns " " (1 byte is only half a DBCS character and a space character is returned instead).</paragraph>
-<paragraph id="par_id2949151" role="paragraph"><item type="input">=LEFTB("中国";2)</item> returns "中" (2 bytes constitute one complete DBCS character).</paragraph>
-<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>
+<section id="leftb"><embed href="text/scalc/01/func_leftb.xhp#func_leftb"/></section>
 
 <section id="len"><embed href="text/scalc/01/func_len.xhp#func_len"/></section>
 
-<section id="lenb">
-<bookmark branch="index" id="bm_id2956110">
-  <bookmark_value>LENB function</bookmark_value>
-</bookmark>
-
-<bookmark branch="hid/SC_HID_FUNC_LENB" id="bm_id2954050" localize="false"/>
-
-<h2 id="hd_id2956110"><variable id="lenbvar"><link href="text/scalc/01/04060110.xhp#lenb">LENB</link></variable></h2>
-<paragraph id="par_id2950147" role="paragraph"><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"/>
-<paragraph id="par_id2954063" role="code">LENB("Text")</paragraph>
-<paragraph id="par_id2946894" role="paragraph"><emph>Text</emph> is the text whose length is to be determined.</paragraph>
-
-<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id2956018" role="paragraph"><item type="input">LENB("中")</item> returns 2 (1 DBCS character consisting of 2 bytes).</paragraph>
-<paragraph id="par_id2956028" role="paragraph"><item type="input">LENB("中国")</item> returns 4 (2 DBCS characters each consisting of 2 bytes).</paragraph>
-<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>
+<section id="lenb"><embed href="text/scalc/01/func_lenb.xhp#func_lenb"/></section>
 
 <section id="lower"><embed href="text/scalc/01/func_lower.xhp#func_lower"/></section>
 
-<section id="mid">
-<bookmark branch="index" id="bm_id3154589">
-  <bookmark_value>MID function</bookmark_value>
-</bookmark>
-
-<bookmark branch="hid/SC_HID_FUNC_TEIL" id="bm_id3155392" localize="false"/>
-
-<h2 id="hd_id3154589">MID</h2>
-<paragraph id="par_id3154938" role="paragraph"><ahelp hid="HID_FUNC_TEIL">Returns a text string of a text. The parameters specify the starting position and the number of characters.</ahelp></paragraph>
+<section id="mid"><embed href="text/scalc/01/func_mid.xhp#func_mid"/></section>
 
-<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3150526" role="code">MID("Text"; Start; Number)</paragraph>
-<paragraph id="par_id3148820" role="paragraph"> <emph>Text</emph> is the text containing the characters to extract.</paragraph>
-<paragraph id="par_id3150774" role="paragraph"> <emph>Start</emph> is the position of the first character in the text to extract.</paragraph>
-<paragraph id="par_id3153063" role="paragraph"> <emph>Number</emph> specifies the number of characters in the part of the text.</paragraph>
-
-<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3158407" role="paragraph"> <item type="input">=MID("office";2;2)</item> returns ff.</paragraph>
-</section>
-
-<section id="midb">
-<bookmark branch="index" id="bm_id2954589">
-  <bookmark_value>MIDB function</bookmark_value>
-</bookmark>
-
-<bookmark branch="hid/SC_HID_FUNC_MIDB" id="bm_id2955392" localize="false"/>
-
-<h2 id="hd_id2954589"><variable id="midbvar"><link href="text/scalc/01/04060110.xhp#midb">MIDB</link></variable></h2>
-<paragraph id="par_id2954938" role="paragraph"><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"/>
-<paragraph id="par_id2950526" role="code">MIDB("Text"; Start; Number_bytes)</paragraph>
-<paragraph id="par_id2948820" role="paragraph"><emph>Text</emph> is the text containing the characters to extract.</paragraph>
-<paragraph id="par_id2950774" role="paragraph"><emph>Start</emph> is the position of the first character in the text to extract.</paragraph>
-<paragraph id="par_id2953063" role="paragraph"><emph>Number_bytes</emph> specifies the number of characters MIDB will return from text, in bytes.</paragraph>
-
-<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id2958417" role="paragraph"><item type="input">=MIDB("中国";1;0)</item> returns "" (0 bytes is always an empty string).</paragraph>
-<paragraph id="par_id2958427" role="paragraph"><item type="input">=MIDB("中国";1;1)</item> returns " " (1 byte is only half a DBCS character and therefore the result is a space character).</paragraph>
-<paragraph id="par_id2958437" role="paragraph"><item type="input">=MIDB("中国";1;2)</item> returns "中" (2 bytes constitute one complete DBCS character).</paragraph>
-<paragraph id="par_id2958447" role="paragraph"><item type="input">=MIDB("中国";1;3)</item> returns "中 " (3 bytes constitute one and a half DBCS character; the last byte results in a space character).</paragraph>
-<paragraph id="par_id2958457" role="paragraph"><item type="input">=MIDB("中国";1;4)</item> returns "中国" (4 bytes constitute two complete DBCS characters).</paragraph>
-<paragraph id="par_id2958467" role="paragraph"><item type="input">=MIDB("中国";2;1)</item> returns " " (byte position 2 is not at the beginning of a character in a DBCS string; 1 space character is returned).</paragraph>
-<paragraph id="par_id2958477" role="paragraph"><item type="input">=MIDB("中国";2;2)</item> returns " " (byte position 2 points to the last half of the first character in the DBCS string; the 2 bytes asked for therefore constitutes the last half of the first character and the first half of the second character in the string; 2 space characters are therefore returned).</paragraph>
-<paragraph id="par_id2958487" role="paragraph"><item type="input">=MIDB("中国";2;3)</item> returns " 国" (byte position 2 is not at the beginning of a character in a DBCS string; a space character is returned for byte position 2).</paragraph>
-<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>
+<section id="midb"><embed href="text/scalc/01/func_midb.xhp#func_midb"/></section>
 
 <section id="proper"><embed href="text/scalc/01/func_proper.xhp#func_proper"/></section>
 
@@ -233,28 +146,7 @@
 
 <section id="right"><embed href="text/scalc/01/func_right.xhp#func_right"/></section>
 
-<section id="rightb">
-<bookmark branch="index" id="bm_id2949805">
-  <bookmark_value>RIGHTB function</bookmark_value>
-</bookmark>
-
-<bookmark branch="hid/SC_HID_FUNC_RIGHTB" id="bm_id2954602" localize="false"/>
-
-<h2 id="hd_id2949805"><variable id="rightbvar"><link href="text/scalc/01/04060110.xhp#rightb">RIGHTB</link></variable></h2>
-<paragraph id="par_id2945375" role="paragraph"><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"/>
-<paragraph id="par_id2954344" role="code">RIGHTB("Text" [; Number_bytes])</paragraph>
-<paragraph id="par_id2949426" role="paragraph"><emph>Text</emph> is the text of which the right part is to be determined.</paragraph>
-<paragraph id="par_id2953350" role="paragraph"><emph>Number_bytes</emph> (optional) specifies the number of characters you want RIGHTB to extract, based on bytes. If this parameter is not defined, one byte is returned.</paragraph>
-
-<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id2951132" role="paragraph"><item type="input">RIGHTB("中国";1)</item> returns " " (1 byte is only half a DBCS character and a space character is returned instead).</paragraph>
-<paragraph id="par_id2951142" role="paragraph"><item type="input">RIGHTB("中国";2)</item> returns "国" (2 bytes constitute one complete DBCS character).</paragraph>
-<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>
+<section id="rightb"><embed href="text/scalc/01/func_rightb.xhp#func_rightb"/></section>
 
 <section id="roman">
   <embed href="text/scalc/01/func_roman.xhp#func_roman"/>
diff --git a/source/text/scalc/01/func_leftb.xhp b/source/text/scalc/01/func_leftb.xhp
new file mode 100644
index 0000000000..674d15752a
--- /dev/null
+++ b/source/text/scalc/01/func_leftb.xhp
@@ -0,0 +1,41 @@
+<?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="calcfunc_leftb" indexer="include" status="PUBLISH">
+      <title id="tit">LEFTB Function</title>
+      <filename>/text/scalc/01/func_leftb.xhp</filename>
+    </topic>
+  </meta>
+  <body>
+
+<bookmark branch="index" id="bm_id2947083">
+  <bookmark_value>LEFTB function</bookmark_value>
+</bookmark>
+
+<bookmark branch="hid/SC_HID_FUNC_LEFTB" id="bm_id2954645" localize="false"/>
+<section id="func_leftb">
+<h1 id="hd_id2947083"><variable id="leftbvar"><link href="text/scalc/01/func_leftb.xhp">LEFTB</link></variable></h1>
+<paragraph id="par_id2953622" role="paragraph"><ahelp hid="HID_FUNC_LEFTB">Returns the first characters of a DBCS text.</ahelp></paragraph>
+</section>
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
+<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
+<paragraph id="par_id2946786" role="code">LEFTB("Text" [; Number_bytes])</paragraph>
+<paragraph id="par_id2947274" role="paragraph"><emph>Text</emph> is the text where the initial partial words are to be determined.</paragraph>
+<paragraph id="par_id2953152" role="paragraph"><emph>Number_bytes</emph> (optional) specifies the number of characters you want LEFTB to extract, based on bytes. If this parameter is not defined, one character is returned.</paragraph>
+
+<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+<paragraph id="par_id2949141" role="paragraph"><item type="input">=LEFTB("中国";1)</item> returns " " (1 byte is only half a DBCS character and a space character is returned instead).</paragraph>
+<paragraph id="par_id2949151" role="paragraph"><item type="input">=LEFTB("中国";2)</item> returns "中" (2 bytes constitute one complete DBCS character).</paragraph>
+<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>
+  </body>
+</helpdocument>
diff --git a/source/text/scalc/01/func_lenb.xhp b/source/text/scalc/01/func_lenb.xhp
new file mode 100644
index 0000000000..ebf0a71c84
--- /dev/null
+++ b/source/text/scalc/01/func_lenb.xhp
@@ -0,0 +1,41 @@
+<?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="calcfunc_lenb" indexer="include" status="PUBLISH">
+      <title id="tit">LENB Function</title>
+      <filename>/text/scalc/01/func_lenb.xhp</filename>
+    </topic>
+  </meta>
+  <body>
+
+<bookmark branch="index" id="bm_id2956110">
+  <bookmark_value>LENB function</bookmark_value>
+</bookmark>
+
+<bookmark branch="hid/SC_HID_FUNC_LENB" id="bm_id2954050" localize="false"/>
+
+<section id="func_lenb">
+<h1 id="hd_id2956110"><variable id="lenbvar"><link href="text/scalc/01/func_lenb.xhp">LENB</link></variable></h1>
+<paragraph id="par_id2950147" role="paragraph"><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>
+</section>
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
+<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
+<paragraph id="par_id2954063" role="code">LENB("Text")</paragraph>
+<paragraph id="par_id2946894" role="paragraph"><emph>Text</emph> is the text whose length is to be determined.</paragraph>
+
+<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+<paragraph id="par_id2956018" role="paragraph"><item type="input">LENB("中")</item> returns 2 (1 DBCS character consisting of 2 bytes).</paragraph>
+<paragraph id="par_id2956028" role="paragraph"><item type="input">LENB("中国")</item> returns 4 (2 DBCS characters each consisting of 2 bytes).</paragraph>
+<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>
+  </body>
+</helpdocument>
diff --git a/source/text/scalc/01/func_mid.xhp b/source/text/scalc/01/func_mid.xhp
new file mode 100644
index 0000000000..b70c6e0981
--- /dev/null
+++ b/source/text/scalc/01/func_mid.xhp
@@ -0,0 +1,40 @@
+<?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="calcfunc_mid" indexer="include" status="PUBLISH">
+      <title id="tit">MID Function</title>
+      <filename>/text/scalc/01/func_mid.xhp</filename>
+    </topic>
+  </meta>
+  <body>
+    <bookmark branch="index" id="bm_id3154589">
+  <bookmark_value>MID function</bookmark_value>
+</bookmark>
+    <bookmark branch="hid/SC_HID_FUNC_TEIL" id="bm_id3155392" localize="false"/>
+    <section id="func_mid">
+      <h1 id="hd_id3154589">
+        <variable id="mid_h1">
+          <link href="text/scalc/01/func_mid.xhp">MID</link>
+        </variable>
+      </h1>
+      <paragraph id="par_id3154938" role="paragraph">
+        <ahelp hid="HID_FUNC_TEIL">Returns a text string of a text. The parameters specify the starting position and the number of characters.</ahelp>
+      </paragraph>
+    </section>
+    <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
+    <paragraph id="par_id3150526" role="code">MID("Text"; Start; Number)</paragraph>
+    <paragraph id="par_id3148820" role="paragraph"> <emph>Text</emph> is the text containing the characters to extract.</paragraph>
+    <paragraph id="par_id3150774" role="paragraph"> <emph>Start</emph> is the position of the first character in the text to extract.</paragraph>
+    <paragraph id="par_id3153063" role="paragraph"> <emph>Number</emph> specifies the number of characters in the part of the text.</paragraph>
+    <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+    <paragraph id="par_id3158407" role="paragraph"> <item type="input">=MID("office";2;2)</item> returns ff.</paragraph>
+  </body>
+</helpdocument>
diff --git a/source/text/scalc/01/func_midb.xhp b/source/text/scalc/01/func_midb.xhp
new file mode 100644
index 0000000000..0e9b97ff9b
--- /dev/null
+++ b/source/text/scalc/01/func_midb.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="calcfunc_midb" indexer="include" status="PUBLISH">
+      <title id="tit">MIDB Function</title>
+      <filename>/text/scalc/01/func_midb.xhp</filename>
+    </topic>
+  </meta>
+  <body>
+
+<bookmark branch="index" id="bm_id2954589">
+  <bookmark_value>MIDB function</bookmark_value>
+</bookmark>
+
+<bookmark branch="hid/SC_HID_FUNC_MIDB" id="bm_id2955392" localize="false"/>
+
+ <section id="func_midb">
+ <h1 id="hd_id2954589"><variable id="midbvar"><link href="text/scalc/01/func_midb.xhp">MIDB</link></variable></h1>
+<paragraph id="par_id2954938" role="paragraph"><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>
+</section>
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
+<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
+<paragraph id="par_id2950526" role="code">MIDB("Text"; Start; Number_bytes)</paragraph>
+<paragraph id="par_id2948820" role="paragraph"><emph>Text</emph> is the text containing the characters to extract.</paragraph>
+<paragraph id="par_id2950774" role="paragraph"><emph>Start</emph> is the position of the first character in the text to extract.</paragraph>
+<paragraph id="par_id2953063" role="paragraph"><emph>Number_bytes</emph> specifies the number of characters MIDB will return from text, in bytes.</paragraph>
+
+<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+<paragraph id="par_id2958417" role="paragraph"><item type="input">=MIDB("中国";1;0)</item> returns "" (0 bytes is always an empty string).</paragraph>
+<paragraph id="par_id2958427" role="paragraph"><item type="input">=MIDB("中国";1;1)</item> returns " " (1 byte is only half a DBCS character and therefore the result is a space character).</paragraph>
+<paragraph id="par_id2958437" role="paragraph"><item type="input">=MIDB("中国";1;2)</item> returns "中" (2 bytes constitute one complete DBCS character).</paragraph>
+<paragraph id="par_id2958447" role="paragraph"><item type="input">=MIDB("中国";1;3)</item> returns "中 " (3 bytes constitute one and a half DBCS character; the last byte results in a space character).</paragraph>
+<paragraph id="par_id2958457" role="paragraph"><item type="input">=MIDB("中国";1;4)</item> returns "中国" (4 bytes constitute two complete DBCS characters).</paragraph>
+<paragraph id="par_id2958467" role="paragraph"><item type="input">=MIDB("中国";2;1)</item> returns " " (byte position 2 is not at the beginning of a character in a DBCS string; 1 space character is returned).</paragraph>
+<paragraph id="par_id2958477" role="paragraph"><item type="input">=MIDB("中国";2;2)</item> returns " " (byte position 2 points to the last half of the first character in the DBCS string; the 2 bytes asked for therefore constitutes the last half of the first character and the first half of the second character in the string; 2 space characters are therefore returned).</paragraph>
+<paragraph id="par_id2958487" role="paragraph"><item type="input">=MIDB("中国";2;3)</item> returns " 国" (byte position 2 is not at the beginning of a character in a DBCS string; a space character is returned for byte position 2).</paragraph>
+<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>
+  </body>
+</helpdocument>
diff --git a/source/text/scalc/01/func_rightb.xhp b/source/text/scalc/01/func_rightb.xhp
new file mode 100644
index 0000000000..b297ce50bd
--- /dev/null
+++ b/source/text/scalc/01/func_rightb.xhp
@@ -0,0 +1,41 @@
+<?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="calcfunc_rightb" indexer="include" status="PUBLISH">
+      <title id="tit">RIGHTB Function</title>
+      <filename>/text/scalc/01/func_rightb.xhp</filename>
+    </topic>
+  </meta>
+  <body>
+    
+<bookmark branch="index" id="bm_id2949805">
+  <bookmark_value>RIGHTB function</bookmark_value>
+</bookmark>
+
+<bookmark branch="hid/SC_HID_FUNC_RIGHTB" id="bm_id2954602" localize="false"/>
+<section id="func_rightb">
+<h1 id="hd_id2949805"><variable id="rightbvar"><link href="text/scalc/01/func_rightb.xhp">RIGHTB</link></variable></h1>
+<paragraph id="par_id2945375" role="paragraph"><ahelp hid="HID_FUNC_RIGHTB">Returns the last character or characters of a text with double bytes characters sets (DBCS).</ahelp></paragraph>
+</section>
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
+<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
+<paragraph id="par_id2954344" role="code">RIGHTB("Text" [; Number_bytes])</paragraph>
+<paragraph id="par_id2949426" role="paragraph"><emph>Text</emph> is the text of which the right part is to be determined.</paragraph>
+<paragraph id="par_id2953350" role="paragraph"><emph>Number_bytes</emph> (optional) specifies the number of characters you want RIGHTB to extract, based on bytes. If this parameter is not defined, one byte is returned.</paragraph>
+
+<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+<paragraph id="par_id2951132" role="paragraph"><item type="input">RIGHTB("中国";1)</item> returns " " (1 byte is only half a DBCS character and a space character is returned instead).</paragraph>
+<paragraph id="par_id2951142" role="paragraph"><item type="input">RIGHTB("中国";2)</item> returns "国" (2 bytes constitute one complete DBCS character).</paragraph>
+<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>
+  </body>
+</helpdocument>