AllLangHelp_scalc.mk | 5 +
source/text/scalc/01/04060110.xhp | 118 +----------------------------------
source/text/scalc/01/func_leftb.xhp | 41 ++++++++++++
source/text/scalc/01/func_lenb.xhp | 41 ++++++++++++
source/text/scalc/01/func_mid.xhp | 40 +++++++++++
source/text/scalc/01/func_midb.xhp | 49 ++++++++++++++
source/text/scalc/01/func_rightb.xhp | 41 ++++++++++++
7 files changed, 222 insertions(+), 113 deletions(-)
New commits:
commit b0473042ff89f94b04e9c7ebe0cfeb5750c2cc4b
Author: Pierre F <f...@bger.ch>
AuthorDate: Wed Nov 6 17:17:14 2024 +0200
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Sat Nov 9 00:11:28 2024 +0100
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.hal...@libreoffice.org>
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>
