summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@edx.srv.br>2014-06-29 18:06:42 -0300
committerCaolán McNamara <caolanm@redhat.com>2014-06-30 09:15:27 +0000
commit5a0344117e741d078b564f54f07333946a6567c4 (patch)
treeb7f31c417bc6082298709105faceafa1be36acf4
parentf4ae6be5fabc4f86cffacb5b6d4fd5eb6568a02f (diff)
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>
-rw-r--r--source/text/scalc/01/04060110.xhp57
1 files changed, 57 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp
index 557fb7f43..e55d4b903 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>