source/text/scalc/01/04060110.xhp | 26 +++++++++++++-------------
1 file changed, 13 insertions(+), 13 deletions(-)
New commits:
commit 5eac8cf1a7d652c4ab41f4a39cc1095198660808
Author: Steve Fanning <stevemfann...@yahoo.co.uk>
AuthorDate: Thu Jul 1 20:14:32 2021 +0200
Commit: Olivier Hallot <olivier.hal...@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.hal...@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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
