source/text/scalc/01/04060115.xhp | 68 +++++++++++++++++++-------------------
source/text/scalc/01/04060116.xhp | 18 +++++-----
2 files changed, 43 insertions(+), 43 deletions(-)
New commits:
commit c28f19ed966fb82a25707d6fcfe60cfbb6164386
Author: Mike Kaganski <mike.kagan...@collabora.com>
AuthorDate: Fri Jun 24 10:20:43 2022 +0200
Commit: Adolfo Jayme Barrientos <fit...@ubuntu.com>
CommitDate: Sat Jun 25 11:51:58 2022 +0200
Fix (BIN|OCT|DEC|HEX)2(BIN|OCT|DEC|HEX) to mention string arguments
... and return types, and also fix the conceptually incorrect examples
Change-Id: I9953d546c0c6ee8f224b866643f6975e538f44f5
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136378
Tested-by: Jenkins
Reviewed-by: Mike Kaganski <mike.kagan...@collabora.com>
(cherry picked from commit 7a93d6a4ae5adb871cbd7cd54f4cc71fed63e27e)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136420
Reviewed-by: Adolfo Jayme Barrientos <fit...@ubuntu.com>
diff --git a/source/text/scalc/01/04060115.xhp
b/source/text/scalc/01/04060115.xhp
index 2629e93d0..aefa271d7 100644
--- a/source/text/scalc/01/04060115.xhp
+++ b/source/text/scalc/01/04060115.xhp
@@ -130,14 +130,14 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_BIN2DEC"
id="bm_id3151230" localize="false"/>
<h2 id="hd_id3153034">BIN2DEC</h2>
-<paragraph id="par_id3144744" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_BIN2DEC">The result is the decimal number for the binary
number entered.</ahelp></paragraph>
+<paragraph id="par_id3144744" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_BIN2DEC">The result is the number for the binary (base-2)
number string entered.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3149726" role="code"
xml-lang="en-US">BIN2DEC(Number)</paragraph>
-<paragraph id="par_id3150142" role="paragraph" xml-lang="en-US">
<emph>Number</emph> is a binary number. The number can have a maximum of 10
places (bits). The most significant bit is the sign bit. Negative numbers are
entered as two's complement.</paragraph>
+<paragraph id="par_id3150142" role="paragraph" xml-lang="en-US">
<emph>Number</emph> is a string representing a binary (base-2) number. It can
have a maximum of 10 places (bits). The most significant bit is the sign bit.
Negative numbers are entered as two's complement.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3145138" role="paragraph" xml-lang="en-US"> <item
type="input">=BIN2DEC(1100100)</item> returns 100.</paragraph>
+<paragraph id="par_id3145138" role="paragraph" xml-lang="en-US"><item
type="input">=BIN2DEC("1100100")</item> returns 100.</paragraph>
</section>
<section id="bin2hex">
@@ -149,15 +149,15 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_BIN2HEX"
id="bm_id3149548" localize="false"/>
<h2 id="hd_id3149954">BIN2HEX</h2>
-<paragraph id="par_id3148585" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_BIN2HEX">The result is the hexadecimal number for the binary
number entered.</ahelp></paragraph>
+<paragraph id="par_id3148585" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_BIN2HEX">The result is the string representing the number in
hexadecimal form for the binary (base-2) number string
entered.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3148753" role="code" xml-lang="en-US">BIN2HEX(Number [;
Places])</paragraph>
-<paragraph id="par_id3155255" role="paragraph" xml-lang="en-US">
<emph>Number</emph> is a binary number. The number can have a maximum of 10
places (bits). The most significant bit is the sign bit. Negative numbers are
entered as two's complement.</paragraph>
-<paragraph id="par_id3150860" role="paragraph" xml-lang="en-US">Places means
the number of places to be output.</paragraph>
+<paragraph id="par_id3155255" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is a string representing a binary (base-2)
number. It can have a maximum of 10 places (bits). The most significant bit is
the sign bit. Negative numbers are entered as two's complement.</paragraph>
+<paragraph id="par_id3150860" role="paragraph"
xml-lang="en-US"><emph>Places</emph> means the number of places to be
output.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3149686" role="paragraph" xml-lang="en-US"> <item
type="input">=BIN2HEX(1100100;6)</item> returns 000064.</paragraph>
+<paragraph id="par_id3149686" role="paragraph" xml-lang="en-US"><item
type="input">=BIN2HEX("1100100";6)</item> returns "000064".</paragraph>
</section>
<section id="bin2oct">
@@ -169,15 +169,15 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_BIN2OCT"
id="bm_id3146848" localize="false"/>
<h2 id="hd_id3153332">BIN2OCT</h2>
-<paragraph id="par_id3155951" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_BIN2OCT"> The result is the octal number for the binary
number entered.</ahelp></paragraph>
+<paragraph id="par_id3155951" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_BIN2OCT">The result is the string representing the number in
octal form for the binary (base-2) number string entered.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3154508" role="code" xml-lang="en-US">BIN2OCT(Number [;
Places])</paragraph>
-<paragraph id="par_id3153567" role="paragraph" xml-lang="en-US">
<emph>Number</emph> is a binary number. The number can have a maximum of 10
places (bits). The most significant bit is the sign bit. Negative numbers are
entered as two's complement.</paragraph>
-<paragraph id="par_id3155929" role="paragraph" xml-lang="en-US">
<emph>Places</emph> means the number of places to be output.</paragraph>
+<paragraph id="par_id3153567" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is a string representing a binary (base-2)
number. It can have a maximum of 10 places (bits). The most significant bit is
the sign bit. Negative numbers are entered as two's complement.</paragraph>
+<paragraph id="par_id3155929" role="paragraph"
xml-lang="en-US"><emph>Places</emph> means the number of places to be
output.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3153733" role="paragraph" xml-lang="en-US"> <item
type="input">=BIN2OCT(1100100;4)</item> returns 0144.</paragraph>
+<paragraph id="par_id3153733" role="paragraph" xml-lang="en-US"><item
type="input">=BIN2OCT("1100100";4)</item> returns "0144".</paragraph>
</section>
<section id="delta">
@@ -207,15 +207,15 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_DEC2BIN"
id="bm_id3148389" localize="false"/>
<h2 id="hd_id3157971">DEC2BIN</h2>
-<paragraph id="par_id3153043" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_DEC2BIN"> The result is the binary number for the decimal
number entered between -512 and 511.</ahelp></paragraph>
+<paragraph id="par_id3153043" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_DEC2BIN">The result is the string representing the number in
binary (base-2) form for the number entered.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3150569" role="code" xml-lang="en-US">DEC2BIN(Number [;
Places])</paragraph>
-<paragraph id="par_id3148768" role="paragraph" xml-lang="en-US">
<emph>Number</emph> is a decimal number. If Number is negative, the function
returns a binary number with 10 characters. The most significant bit is the
sign bit, the other 9 bits return the value.</paragraph>
-<paragraph id="par_id3149537" role="paragraph" xml-lang="en-US">
<emph>Places</emph> means the number of places to be output.</paragraph>
+<paragraph id="par_id3148768" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is a number between -512 and 511. If
Number is negative, the function returns a binary number string with 10
characters. The most significant bit is the sign bit, the other 9 bits return
the value.</paragraph>
+<paragraph id="par_id3149537" role="paragraph"
xml-lang="en-US"><emph>Places</emph> means the number of places to be
output.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3150662" role="paragraph" xml-lang="en-US"> <item
type="input">=DEC2BIN(100;8)</item> returns 01100100.</paragraph>
+<paragraph id="par_id3150662" role="paragraph" xml-lang="en-US"><item
type="input">=DEC2BIN(100;8)</item> returns "01100100".</paragraph>
</section>
<section id="dec2hex">
@@ -227,15 +227,15 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_DEC2HEX"
id="bm_id3155513" localize="false"/>
<h2 id="hd_id3149388">DEC2HEX</h2>
-<paragraph id="par_id3149030" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_DEC2HEX">The result is the hexadecimal number for the decimal
number entered.</ahelp></paragraph>
+<paragraph id="par_id3149030" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_DEC2HEX">The result is the string representing the number in
hexadecimal form for the number entered.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3147535" role="code" xml-lang="en-US">DEC2HEX(Number [;
Places])</paragraph>
-<paragraph id="par_id3152820" role="paragraph" xml-lang="en-US">
<emph>Number</emph> is a decimal number. If Number is negative, the function
returns a hexadecimal number with 10 characters (40 bits). The most significant
bit is the sign bit, the other 39 bits return the value.</paragraph>
-<paragraph id="par_id3153221" role="paragraph" xml-lang="en-US">
<emph>Places</emph> means the number of places to be output.</paragraph>
+<paragraph id="par_id3152820" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is a number. If Number is negative, the
function returns a hexadecimal number string with 10 characters (40 bits). The
most significant bit is the sign bit, the other 39 bits return the
value.</paragraph>
+<paragraph id="par_id3153221" role="paragraph"
xml-lang="en-US"><emph>Places</emph> means the number of places to be
output.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3150476" role="paragraph" xml-lang="en-US"> <item
type="input">=DEC2HEX(100;4)</item> returns 0064.</paragraph>
+<paragraph id="par_id3150476" role="paragraph" xml-lang="en-US"><item
type="input">=DEC2HEX(100;4)</item> returns "0064".</paragraph>
</section>
<section id="dec2oct">
@@ -247,15 +247,15 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_DEC2OCT"
id="bm_id3156260" localize="false"/>
<h2 id="hd_id3154948">DEC2OCT</h2>
-<paragraph id="par_id3153920" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_DEC2OCT">The result is the octal number for the decimal
number entered.</ahelp></paragraph>
+<paragraph id="par_id3153920" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_DEC2OCT">The result is the string representing the number in
octal form for the number entered.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3148427" role="code" xml-lang="en-US">DEC2OCT(Number [;
Places])</paragraph>
-<paragraph id="par_id3155991" role="paragraph" xml-lang="en-US">
<emph>Number</emph> is a decimal number. If Number is negative, the function
returns an octal number with 10 characters (30 bits). The most significant bit
is the sign bit, the other 29 bits return the value.</paragraph>
-<paragraph id="par_id3152587" role="paragraph" xml-lang="en-US">
<emph>Places</emph> means the number of places to be output.</paragraph>
+<paragraph id="par_id3155991" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is a number. If Number is negative, the
function returns an octal number string with 10 characters (30 bits). The most
significant bit is the sign bit, the other 29 bits return the value.</paragraph>
+<paragraph id="par_id3152587" role="paragraph"
xml-lang="en-US"><emph>Places</emph> means the number of places to be
output.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3154317" role="paragraph" xml-lang="en-US"> <item
type="input">=DEC2OCT(100;4)</item> returns 0144.</paragraph>
+<paragraph id="par_id3154317" role="paragraph" xml-lang="en-US"><item
type="input">=DEC2OCT(100;4)</item> returns "0144".</paragraph>
</section>
<section id="erf">
@@ -366,15 +366,15 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_HEX2BIN"
id="bm_id3145659" localize="false"/>
<h2 id="hd_id3147276">HEX2BIN</h2>
-<paragraph id="par_id3150258" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_HEX2BIN">The result is the binary number for the hexadecimal
number entered.</ahelp></paragraph>
+<paragraph id="par_id3150258" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_HEX2BIN">The result is the the string representing the number
in binary (base-2) form for the hexadecimal number string
entered.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3155847" role="code" xml-lang="en-US">HEX2BIN(Number [;
Places])</paragraph>
-<paragraph id="par_id3152810" role="paragraph" xml-lang="en-US">
<emph>Number</emph> is a hexadecimal number or a string that represents a
hexadecimal number. It can have a maximum of 10 places. The most significant
bit is the sign bit, the following bits return the value. Negative numbers are
entered as two's complement.</paragraph>
-<paragraph id="par_id3153758" role="paragraph" xml-lang="en-US">
<emph>Places</emph> is the number of places to be output.</paragraph>
+<paragraph id="par_id3152810" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is a string that represents a hexadecimal
number. It can have a maximum of 10 places. The most significant bit is the
sign bit, the following bits return the value. Negative numbers are entered as
two's complement.</paragraph>
+<paragraph id="par_id3153758" role="paragraph"
xml-lang="en-US"><emph>Places</emph> is the number of places to be
output.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3156002" role="paragraph" xml-lang="en-US"> <item
type="input">=HEX2BIN("6a";8)</item> returns 01101010.</paragraph>
+<paragraph id="par_id3156002" role="paragraph" xml-lang="en-US"><item
type="input">=HEX2BIN("6a";8)</item> returns "01101010".</paragraph>
</section>
<section id="hex2dec">
@@ -386,14 +386,14 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_HEX2DEC"
id="bm_id3149978" localize="false"/>
<h2 id="hd_id3154742">HEX2DEC</h2>
-<paragraph id="par_id3153626" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_HEX2DEC">The result is the decimal number for the hexadecimal
number entered.</ahelp></paragraph>
+<paragraph id="par_id3153626" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_HEX2DEC">The result is the number for the hexadecimal number
string entered.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3149293" role="code"
xml-lang="en-US">HEX2DEC(Number)</paragraph>
-<paragraph id="par_id3159176" role="paragraph" xml-lang="en-US">
<emph>Number</emph> is a hexadecimal number or a string that represents a
hexadecimal number. It can have a maximum of 10 places. The most significant
bit is the sign bit, the following bits return the value. Negative numbers are
entered as two's complement.</paragraph>
+<paragraph id="par_id3159176" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is a string that represents a hexadecimal
number. It can have a maximum of 10 places. The most significant bit is the
sign bit, the following bits return the value. Negative numbers are entered as
two's complement.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3146093" role="paragraph" xml-lang="en-US"> <item
type="input">=HEX2DEC("6a")</item> returns 106.</paragraph>
+<paragraph id="par_id3146093" role="paragraph" xml-lang="en-US"><item
type="input">=HEX2DEC("6a")</item> returns 106.</paragraph>
</section>
<section id="hex2oct">
@@ -405,15 +405,15 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_HEX2OCT"
id="bm_id3147487" localize="false"/>
<h2 id="hd_id3149750">HEX2OCT</h2>
-<paragraph id="par_id3153983" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_HEX2OCT">The result is the octal number for the hexadecimal
number entered.</ahelp></paragraph>
+<paragraph id="par_id3153983" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_HEX2OCT">The result is the string representing the number in
octal form for the hexadecimal number string entered.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3151170" role="code" xml-lang="en-US">HEX2OCT(Number [;
Places])</paragraph>
-<paragraph id="par_id3152795" role="paragraph" xml-lang="en-US">
<emph>Number</emph> is a hexadecimal number or a string that represents a
hexadecimal number. It can have a maximum of 10 places. The most significant
bit is the sign bit, the following bits return the value. Negative numbers are
entered as two's complement.</paragraph>
-<paragraph id="par_id3149204" role="paragraph" xml-lang="en-US">
<emph>Places</emph> is the number of places to be output.</paragraph>
+<paragraph id="par_id3152795" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is a string that represents a hexadecimal
number. It can have a maximum of 10 places. The most significant bit is the
sign bit, the following bits return the value. Negative numbers are entered as
two's complement.</paragraph>
+<paragraph id="par_id3149204" role="paragraph"
xml-lang="en-US"><emph>Places</emph> is the number of places to be
output.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3159341" role="paragraph" xml-lang="en-US"> <item
type="input">=HEX2OCT("6a";4)</item> returns 0152.</paragraph>
+<paragraph id="par_id3159341" role="paragraph" xml-lang="en-US"><item
type="input">=HEX2OCT("6a";4)</item> returns "0152".</paragraph>
</section>
</sort>
diff --git a/source/text/scalc/01/04060116.xhp
b/source/text/scalc/01/04060116.xhp
index 751af61fb..ad42560a0 100644
--- a/source/text/scalc/01/04060116.xhp
+++ b/source/text/scalc/01/04060116.xhp
@@ -340,16 +340,16 @@
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_OCT2BIN"
id="bm_id3149290" localize="false"/>
<h2 id="hd_id3155103">OCT2BIN</h2>
- <paragraph xml-lang="en-US" id="par_id3146898"
role="paragraph"><ahelp hid="HID_AAI_FUNC_OCT2BIN">The result is the binary
number for the octal number entered.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="par_id3146898"
role="paragraph"><ahelp hid="HID_AAI_FUNC_OCT2BIN">The result is the string
representing the number in binary (base-2) form for the octal number string
entered.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3154303"
role="code">OCT2BIN(Number [; Places])</paragraph>
<paragraph xml-lang="en-US" id="par_id3156013" role="paragraph">
- <emph>Number</emph> is the octal number. The number can have a
maximum of 10 places. The most significant bit is the sign bit, the following
bits return the value. Negative numbers are entered as two's
complement.</paragraph>
+ <emph>Number</emph> is a string that represents an octal number.
It can have a maximum of 10 places. The most significant bit is the sign bit,
the following bits return the value. Negative numbers are entered as two's
complement.</paragraph>
<paragraph xml-lang="en-US" id="par_id3153984" role="paragraph">
<emph>Places</emph> is the number of places to be
output.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3147260" role="paragraph">
- <item type="input">=OCT2BIN(3;3)</item> returns 011.</paragraph>
+ <item type="input">=OCT2BIN("3";3)</item> returns
"011".</paragraph>
</section>
<section id="oct2dec">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3152791"><bookmark_value>OCT2DEC function</bookmark_value>
@@ -357,14 +357,14 @@
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_OCT2DEZ"
id="bm_id3151168" localize="false"/>
<h2 id="hd_id3152791">OCT2DEC</h2>
- <paragraph xml-lang="en-US" id="par_id3149199"
role="paragraph"><ahelp hid="HID_AAI_FUNC_OCT2DEZ">The result is the decimal
number for the octal number entered.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="par_id3149199"
role="paragraph"><ahelp hid="HID_AAI_FUNC_OCT2DEZ">The result is the number for
the octal number string entered.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3153902"
role="code">OCT2DEC(Number)</paragraph>
<paragraph xml-lang="en-US" id="par_id3155326" role="paragraph">
- <emph>Number</emph> is the octal number. The number can have a
maximum of 10 places. The most significant bit is the sign bit, the following
bits return the value. Negative numbers are entered as two's
complement.</paragraph>
+ <emph>Number</emph> is a string that represents an octal number.
It can have a maximum of 10 places. The most significant bit is the sign bit,
the following bits return the value. Negative numbers are entered as two's
complement.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3154930" role="paragraph">
- <item type="input">=OCT2DEC(144)</item> returns 100.</paragraph>
+ <item type="input">=OCT2DEC("144")</item> returns 100.</paragraph>
</section>
<section id="oct2hex">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3155391"><bookmark_value>OCT2HEX function</bookmark_value>
@@ -372,16 +372,16 @@
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_OCT2HEX"
id="bm_id3149904" localize="false"/>
<h2 id="hd_id3155391">OCT2HEX</h2>
- <paragraph xml-lang="en-US" id="par_id3148831"
role="paragraph"><ahelp hid="HID_AAI_FUNC_OCT2HEX"> The result is the
hexadecimal number for the octal number entered.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="par_id3148831"
role="paragraph"><ahelp hid="HID_AAI_FUNC_OCT2HEX">The result is the string
representing the number in hexadecimal form for the octal number string
entered.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3150523"
role="code">OCT2HEX(Number [; Places])</paragraph>
<paragraph xml-lang="en-US" id="par_id3159162" role="paragraph">
- <emph>Number</emph> is the octal number. The number can have a
maximum of 10 places. The most significant bit is the sign bit, the following
bits return the value. Negative numbers are entered as two's
complement.</paragraph>
+ <emph>Number</emph> is a string that represents an octal number.
It can have a maximum of 10 places. The most significant bit is the sign bit,
the following bits return the value. Negative numbers are entered as two's
complement.</paragraph>
<paragraph xml-lang="en-US" id="par_id3145420" role="paragraph">
<emph>Places</emph> is the number of places to be
output.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3148802" role="paragraph">
- <item type="input">=OCT2HEX(144;4)</item> returns 0064.</paragraph>
+ <item type="input">=OCT2HEX("144";4)</item> returns
"0064".</paragraph>
</section>
<section id="convert">
