[Libreoffice-commits] help.git: source/text

Steve Fanning (via logerrit) logerrit at kemper.freedesktop.org
Fri Jul 2 11:51:51 UTC 2021 

 source/text/scalc/01/04060110.xhp |   26 +++++++++++++-------------
 1 file changed, 13 insertions(+), 13 deletions(-)

New commits:
commit 5eac8cf1a7d652c4ab41f4a39cc1095198660808
Author:     Steve Fanning <stevemfanning at yahoo.co.uk>
AuthorDate: Thu Jul 1 20:14:32 2021 +0200
Commit:     Olivier Hallot <olivier.hallot at libreoffice.org>
CommitDate: Fri Jul 2 13:51:27 2021 +0200

    Fix minor typos in help descriptions of Calc's text functions.
    
    (a) Added equals sign before examples given for MIDB function, for consistency with other help topics.
    (b) Added statement of default value for Number argument of RIGHT and RIGHTB functions.
    
    Change-Id: I6de1b35ce1e78e4403f957bb32878f40598a7269
    Reviewed-on: https://gerrit.libreoffice.org/c/help/+/118252
    Tested-by: Jenkins
    Reviewed-by: Olivier Hallot <olivier.hallot at libreoffice.org>

diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp
index aa7109ba8..b0f5778c7 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -495,17 +495,17 @@
 <paragraph id="par_id2953063" role="paragraph" xml-lang="en-US"><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" xml-lang="en-US"><item type="input">MIDB("中国";1;0)</item> returns "" (0 bytes is always an empty string).</paragraph>
-<paragraph id="par_id2958427" role="paragraph" xml-lang="en-US"><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" xml-lang="en-US"><item type="input">MIDB("中国";1;2)</item> returns "中" (2 bytes constitute one complete DBCS character).</paragraph>
-<paragraph id="par_id2958447" role="paragraph" xml-lang="en-US"><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" xml-lang="en-US"><item type="input">MIDB("中国";1;4)</item> returns "中国" (4 bytes constitute two complete DBCS characters).</paragraph>
-<paragraph id="par_id2958467" role="paragraph" xml-lang="en-US"><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" xml-lang="en-US"><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" xml-lang="en-US"><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" xml-lang="en-US"><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" xml-lang="en-US"><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" xml-lang="en-US"><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>
+<paragraph id="par_id2958417" role="paragraph" xml-lang="en-US"><item type="input">=MIDB("中国";1;0)</item> returns "" (0 bytes is always an empty string).</paragraph>
+<paragraph id="par_id2958427" role="paragraph" xml-lang="en-US"><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" xml-lang="en-US"><item type="input">=MIDB("中国";1;2)</item> returns "中" (2 bytes constitute one complete DBCS character).</paragraph>
+<paragraph id="par_id2958447" role="paragraph" xml-lang="en-US"><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" xml-lang="en-US"><item type="input">=MIDB("中国";1;4)</item> returns "中国" (4 bytes constitute two complete DBCS characters).</paragraph>
+<paragraph id="par_id2958467" role="paragraph" xml-lang="en-US"><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" xml-lang="en-US"><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" xml-lang="en-US"><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" xml-lang="en-US"><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" xml-lang="en-US"><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" xml-lang="en-US"><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="proper">
@@ -585,7 +585,7 @@
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
 <paragraph id="par_id3154344" role="code" xml-lang="en-US">RIGHT("Text" [; Number])</paragraph>
 <paragraph id="par_id3149426" role="paragraph" xml-lang="en-US"> <emph>Text</emph> is the text of which the right part is to be determined.</paragraph>
-<paragraph id="par_id3153350" role="paragraph" xml-lang="en-US"> <emph>Number</emph> (optional) is the number of characters from the right part of the text.</paragraph>
+<paragraph id="par_id3153350" role="paragraph" xml-lang="en-US"> <emph>Number</emph> (optional) is the number of characters from the right part of the text. If this parameter is not defined, one character is returned.</paragraph>
 
 <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
 <paragraph id="par_id3151132" role="paragraph" xml-lang="en-US"> <item type="input">=RIGHT("Sun";2)</item> returns un.</paragraph>
@@ -604,7 +604,7 @@
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
 <paragraph id="par_id2954344" role="code" xml-lang="en-US">RIGHTB("Text" [; Number_bytes])</paragraph>
 <paragraph id="par_id2949426" role="paragraph" xml-lang="en-US"><emph>Text</emph> is the text of which the right part is to be determined.</paragraph>
-<paragraph id="par_id2953350" role="paragraph" xml-lang="en-US"><emph>Number_bytes</emph> (optional) specifies the number of characters you want RIGHTB to extract, based on bytes.</paragraph>
+<paragraph id="par_id2953350" role="paragraph" xml-lang="en-US"><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" xml-lang="en-US"><item type="input">RIGHTB("中国";1)</item> returns " " (1 byte is only half a DBCS character and a space character is returned instead).</paragraph>

More information about the Libreoffice-commits mailing list