Difference between revisions of "Documentation/How Tos/Calc: HEX2OCT function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Robot: Automated text replacement %s)
m
 
(3 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
__NOTOC__
+
{{DISPLAYTITLE:HEX2OCT function}}
 +
{{Documentation/CalcFunc Number ConvTOC
 +
|ShowPrevNext=block
 +
|PrevPage=Documentation/How_Tos/Calc:_HEX2DEC_function
 +
|NextPage=Documentation/How_Tos/Calc:_OCT2BIN_function
 +
}}__NOTOC__
  
 
== HEX2OCT ==
 
== HEX2OCT ==
Line 8: Line 13:
 
=== Syntax: ===
 
=== Syntax: ===
 
<tt>'''HEX2OCT(hexadecimalnumber; numdigits)'''</tt>
 
<tt>'''HEX2OCT(hexadecimalnumber; numdigits)'''</tt>
−
: returns text representing an octal number, given <tt>'''hexadecimalnumber'''</tt>, which may be text, or a number (taken to be hexadecimal although it is not).
+
: returns text representing an octal number, given <tt>'''hexadecimalnumber'''</tt>, which may be text, or a number (taken to be hexadecimal, although it is not).
  
 
: The octal number returned may have up to ten digits in twos complement representation; positive numbers are 0 to 3777777777 octal and negative numbers 7777777777 to 4000000000 (a range of -2<sup>29</sup> to 2<sup>29</sup>-1 decimal).
 
: The octal number returned may have up to ten digits in twos complement representation; positive numbers are 0 to 3777777777 octal and negative numbers 7777777777 to 4000000000 (a range of -2<sup>29</sup> to 2<sup>29</sup>-1 decimal).
Line 29: Line 34:
 
: returns <tt>'''7777777776'''</tt> as text (twos complement representation of decimal -2).
 
: returns <tt>'''7777777776'''</tt> as text (twos complement representation of decimal -2).
  
−
{{Documentation/SeeAlso|
+
{{SeeAlso|EN|
 
* [[Documentation/How_Tos/Calc: BIN2DEC function|BIN2DEC]]
 
* [[Documentation/How_Tos/Calc: BIN2DEC function|BIN2DEC]]
 
* [[Documentation/How_Tos/Calc: BIN2HEX function|BIN2HEX]]
 
* [[Documentation/How_Tos/Calc: BIN2HEX function|BIN2HEX]]
Line 44: Line 49:
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
−
[[Category: Documentation/Reference/Calc]]
+
[[Category: Documentation/Reference/Calc/Number Conversion functions]]

Latest revision as of 14:20, 1 February 2024

HEX2OCT

Converts a hexadecimal number to octal.

This function is only available if the Analysis AddIn is installed.

Syntax:

HEX2OCT(hexadecimalnumber; numdigits)

returns text representing an octal number, given hexadecimalnumber, which may be text, or a number (taken to be hexadecimal, although it is not).
The octal number returned may have up to ten digits in twos complement representation; positive numbers are 0 to 3777777777 octal and negative numbers 7777777777 to 4000000000 (a range of -229 to 229-1 decimal).
hexadecimalnumber must therefore also lie in this range, and is given in twos complement form with up to ten digits.
numdigits is an optional number specifying the number of digits to return.

Example:

HEX2OCT("1D")

returns 35 as text.

HEX2OCT(10)

returns 20 as text. The number 10 is read as hexadecimal.

HEX2OCT("1D"; 3)

returns 035 as text. HEX2OCT adds a leading zero to make 3 digits.

HEX2OCT("FFFFFFFFFE")

returns 7777777776 as text (twos complement representation of decimal -2).


See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_HEX2OCT_function&oldid=259935"
Views
Personal tools
Navigation
Tools