Fix fdo#80442, Calc DBCS functions

write help pages for LEFTB, LENB, MIDB and RIGHTB spreadsheet functions working on DBCS

Change-Id: I31e42712f8e8ccbc8ad5ef4f933fcb7974489aa5
Reviewed-on: https://gerrit.libreoffice.org/9970
Reviewed-by: Caolán McNamara <caolanm@redhat.com>
Tested-by: Caolán McNamara <caolanm@redhat.com>

1 files changed, 57 insertions, 0 deletions

diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp
index 557fb7f43e..e55d4b903d 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -321,6 +321,19 @@
          <paragraph xml-lang="en-US" id="par_id3149141" role="paragraph" l10n="U" oldref="102">
             <item type="input">=LEFT("output";3)</item> returns “out”.</paragraph>
       </section>
+      <section id="leftb">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2947083"><bookmark_value>LEFTB function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LEFTB" id="bm_id2954645" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2947083" role="heading" level="2" l10n="U" oldref="95">LEFTB</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2953622" role="paragraph" l10n="CHG" oldref="96"><ahelp hid="HID_FUNC_LEFTB">Returns the first characters of a DBCS text.</ahelp></paragraph>
+         <paragraph xml-lang="en-US" id="hd_id2956116" role="heading" level="3" l10n="U" oldref="97">Syntax</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2946786" role="code" l10n="U" oldref="98">LEFTB("Text"; Number_bytes)</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2947274" role="paragraph" l10n="U" oldref="99"><emph>Text</emph> is the text where the initial partial words are to be determined.</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2953152" role="paragraph" l10n="U" oldref="100"><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>
+         <paragraph xml-lang="en-US" id="hd_id2950260" role="heading" level="3" l10n="U" oldref="101">Example</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2949141" role="paragraph" l10n="U" oldref="102"><item type="input">=LEFTB("output";3)</item> returns “out”.</paragraph>
+      </section>
       <section id="len">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3156110"><bookmark_value>LEN function</bookmark_value>
 </bookmark>
@@ -340,6 +353,21 @@
          <paragraph xml-lang="en-US" id="par_id3154300" role="paragraph" l10n="U" oldref="111">
             <item type="input">=LEN(12345.67)</item> returns 8.</paragraph>
       </section>
+      <section id="lenb">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2956110"><bookmark_value>LENB function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LENB" id="bm_id2954050" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2956110" role="heading" level="2" l10n="U" oldref="104">LENB</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2950147" role="paragraph" l10n="U" oldref="105"><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>
+         <paragraph xml-lang="en-US" id="hd_id2955108" role="heading" level="3" l10n="U" oldref="106">Syntax</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2954063" role="code" l10n="U" oldref="107">LENB("Text")</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2946894" role="paragraph" l10n="U" oldref="108"><emph>Text</emph> is the text whose length is to be determined.</paragraph>
+         <paragraph xml-lang="en-US" id="hd_id2953884" role="heading" level="3" l10n="U" oldref="109">Example</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2956008" role="paragraph" l10n="U" oldref="110">
+             <item type="input">=LENB("Good Afternoon")</item> returns 14.</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2954300" role="paragraph" l10n="U" oldref="111">
+            <item type="input">=LENB(12345.67)</item> returns 8.</paragraph>
+      </section>
       <section id="lower">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3153983"><bookmark_value>LOWER function</bookmark_value>
 </bookmark>
@@ -378,6 +406,21 @@
          <paragraph xml-lang="en-US" id="par_id3158407" role="paragraph" l10n="U" oldref="156">
             <item type="input">=MID("office";2;2)</item> returns ff.</paragraph>
       </section>
+      <section id="midb">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2954589"><bookmark_value>MIDB function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MIDB" id="bm_id2955392" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2954589" role="heading" level="2" l10n="U" oldref="148">MIDB</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2954938" role="paragraph" l10n="CHG" oldref="149"><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>
+         <paragraph xml-lang="en-US" id="hd_id2948829" role="heading" level="3" l10n="U" oldref="150">Syntax</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2950526" role="code" l10n="U" oldref="151">MIDB("Text"; Start; Number_bytes)</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2948820" role="paragraph" l10n="U" oldref="152"><emph>Text</emph> is the text containing the characters to extract.</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2950774" role="paragraph" l10n="U" oldref="153"><emph>Start</emph> is the position of the first character in the text to extract.</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2953063" role="paragraph" l10n="U" oldref="154"><emph>Number_bytes</emph> specifies the number of characters MIDB will return from text, in bytes.</paragraph>
+         <paragraph xml-lang="en-US" id="hd_id2950509" role="heading" level="3" l10n="U" oldref="155">Example</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2958407" role="paragraph" l10n="U" oldref="156">
+            <item type="input">=MIDB("office";2;2)</item> returns ff.</paragraph>
+      </section>
       <section id="proper">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3159143"><bookmark_value>PROPER function</bookmark_value>
 </bookmark>
@@ -458,6 +501,20 @@
          <paragraph xml-lang="en-US" id="par_id3151132" role="paragraph" l10n="U" oldref="120">
             <item type="input">=RIGHT("Sun";2)</item> returns un.</paragraph>
       </section>
+      <section id="rightb">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2949805"><bookmark_value>RIGHTB function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RIGHTB" id="bm_id2954602" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2949805" role="heading" level="2" l10n="U" oldref="113">RIGHTB</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2945375" role="paragraph" l10n="CHG" oldref="114"><ahelp hid="HID_FUNC_RIGHTB">Returns the last character or characters of a text with double bytes characters sets (DBCS).</ahelp></paragraph>
+         <paragraph xml-lang="en-US" id="hd_id2950837" role="heading" level="3" l10n="U" oldref="115">Syntax</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2954344" role="code" l10n="U" oldref="116">RIGHTB("Text"; Number_bytes)</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2949426" role="paragraph" l10n="U" oldref="117"><emph>Text</emph> is the text of which the right part is to be determined.</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2953350" role="paragraph" l10n="U" oldref="118"><emph>Number_bytes</emph> (optional) specifies the number of characters you want RIGHTB to extract, based on bytes.</paragraph>
+         <paragraph xml-lang="en-US" id="hd_id2948661" role="heading" level="3" l10n="U" oldref="119">Example</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2951132" role="paragraph" l10n="U" oldref="120">
+            <item type="input">=RIGHTB("Sun";2)</item> returns un.</paragraph>
+      </section>
       <section id="roman">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3153534"><bookmark_value>ROMAN function</bookmark_value>
 </bookmark>