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

From Apache OpenOffice Wiki
Jump to: navigation, search
(Initial content)
 
(9 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
__NOTOC__
+
{{Documentation/MasterTOC
 +
|bookid=1234'''
 +
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div>
 +
|ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Number_Conversion_functions|<div style="font-size: 140%;">Number Conversion Functions]]
 +
|ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_ARABIC_function
 +
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_OCT2DEC_function
 +
|ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Mathematical_functions
 +
|ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Spreadsheet_functions
 +
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
 +
 
 +
* [[Documentation/How_Tos/Calc:_BIN2DEC_function|<div style="font-size: 120%;">Bin2dec]]
 +
* [[Documentation/How_Tos/Calc:_BIN2HEX_function|<div style="font-size: 120%;">Bin2hex]]
 +
* [[Documentation/How_Tos/Calc:_BIN2OCT_function|<div style="font-size: 120%;">Bin2oct]]
 +
* [[Documentation/How_Tos/Calc:_DEC2BIN_function|<div style="font-size: 120%;">Dec2bin]]
 +
* [[Documentation/How_Tos/Calc:_DEC2HEX_function|<div style="font-size: 120%;">Dec2hex]]
 +
* [[Documentation/How_Tos/Calc:_DEC2OCT_function|<div style="font-size: 120%;">Dec2oct]]
 +
* [[Documentation/How_Tos/Calc:_HEX2BIN_function|<div style="font-size: 120%;">Hex2bin]]
 +
* [[Documentation/How_Tos/Calc:_HEX2DEC_function|<div style="font-size: 120%;">Hex2dec]]
 +
* [[Documentation/How_Tos/Calc:_HEX2OCT_function|<div style="font-size: 120%;">Hex2oct]]
 +
* [[Documentation/How_Tos/Calc:_OCT2BIN_function|<div style="font-size: 120%;">Oct2bin]]
 +
* [[Documentation/How_Tos/Calc:_OCT2DEC_function|<div style="font-size: 120%;">Oct2dec]]
 +
* [[Documentation/How_Tos/Calc:_OCT2HEX_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Oct2hex]]
 +
* [[Documentation/How_Tos/Calc:_ARABIC_function|<div style="font-size: 120%;">Arabic]]
 +
* [[Documentation/How_Tos/Calc:_BAHTTEXT_function|<div style="font-size: 120%;">Bahttext]]
 +
* [[Documentation/How_Tos/Calc:_DECIMAL_function|<div style="font-size: 120%;">Decimal]]
 +
* [[Documentation/How_Tos/Calc:_ROMAN_function|<div style="font-size: 120%;">Roman]]
 +
}}__TOC__
  
 
== OCT2HEX ==
 
== OCT2HEX ==
Line 8: Line 34:
 
=== Syntax: ===
 
=== Syntax: ===
 
<tt>'''OCT2HEX(octalnumber; numdigits)'''</tt>
 
<tt>'''OCT2HEX(octalnumber; numdigits)'''</tt>
−
: returns text representing a hexadecimal number, given <tt>'''octalnumber'''</tt>, which may be text, or a number containing only digits 1 and 0 (thus the number appears to be octal although it is not).
+
: returns text representing a hexadecimal number, given <tt>'''octalnumber'''</tt>, which may be text, or a number containing only digits 0 to 7 (thus the number appears to be octal although it is not).
  
−
: <tt>'''octalnumber'''</tt> may have up to ten bits in two's complement representation; positive numbers are 0 to 111111111 (nine bits representing 0 to 511 decimal) and negative numbers 1111111111 to 1000000000 (ten bits representing -1 to -512 decimal)
+
: <tt>'''octalnumber'''</tt> may have up to ten digit in twos complement representation; positive numbers are 0 to 3777777777 (representing 0 to 2<sup>29</sup>-1 decimal) and negative numbers 7777777777 to 4000000000 (representing -1 to -2<sup>29</sup> decimal).
  
 
: <tt>'''numdigits'''</tt> is an optional number specifying the number of digits to return.
 
: <tt>'''numdigits'''</tt> is an optional number specifying the number of digits to return.
  
−
: If <tt>'''octalnumber'''</tt> is negative, <tt>'''OCT2HEX'''</tt> returns ten hexadecimal digits, representing the hexadecimal number in twos complement form.
+
: If <tt>'''octalnumber'''</tt> is negative, <tt>'''OCT2HEX'''</tt> returns ten octal digits, representing the octal number in twos complement form.
  
 
=== Example: ===
 
=== Example: ===
Line 29: Line 55:
 
: returns <tt>'''FFFFFFFFFE'''</tt> as text (twos complement representation of decimal -2).
 
: returns <tt>'''FFFFFFFFFE'''</tt> as text (twos complement representation of decimal -2).
  
−
=== See also: ===
+
{{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]]
−
[[Documentation/How_Tos/Calc: BIN2OCT function|'''BIN2OCT''']],
+
* [[Documentation/How_Tos/Calc: BIN2OCT function|BIN2OCT]]
−
[[Documentation/How_Tos/Calc: DEC2BIN function|'''DEC2BIN''']],
+
* [[Documentation/How_Tos/Calc: DEC2BIN function|DEC2BIN]]
−
[[Documentation/How_Tos/Calc: DEC2HEX function|'''DEC2HEX''']],
+
* [[Documentation/How_Tos/Calc: DEC2HEX function|DEC2HEX]]
−
[[Documentation/How_Tos/Calc: DEC2OCT function|'''DEC2OCT''']],
+
* [[Documentation/How_Tos/Calc: DEC2OCT function|DEC2OCT]]
−
[[Documentation/How_Tos/Calc: HEX2BIN function|'''HEX2BIN''']],
+
* [[Documentation/How_Tos/Calc: HEX2BIN function|HEX2BIN]]
−
[[Documentation/How_Tos/Calc: HEX2DEC function|'''HEX2DEC''']],
+
* [[Documentation/How_Tos/Calc: HEX2DEC function|HEX2DEC]]
−
[[Documentation/How_Tos/Calc: HEX2OCT function|'''HEX2OCT''']],
+
* [[Documentation/How_Tos/Calc: HEX2OCT function|HEX2OCT]]
−
[[Documentation/How_Tos/Calc: OCT2BIN function|'''OCT2BIN''']],
+
* [[Documentation/How_Tos/Calc: OCT2BIN function|OCT2BIN]]
−
[[Documentation/How_Tos/Calc: OCT2DEC function|'''OCT2DEC''']]
+
* [[Documentation/How_Tos/Calc: OCT2DEC function|OCT2DEC]]
 +
 
 +
* [[Documentation/How_Tos/Calc: Number Conversion functions|Number Conversion functions]]
  
−
'''[[Documentation/How_Tos/Calc: Number Conversion functions|Number Conversion functions]]'''
+
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 +
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 +
[[Category: Documentation/Reference/Calc/Number Conversion functions]]

Revision as of 08:04, 17 July 2018


OCT2HEX

Converts a octal number to hexadecimal.

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

Syntax:

OCT2HEX(octalnumber; numdigits)

returns text representing a hexadecimal number, given octalnumber, which may be text, or a number containing only digits 0 to 7 (thus the number appears to be octal although it is not).
octalnumber may have up to ten digit in twos complement representation; positive numbers are 0 to 3777777777 (representing 0 to 229-1 decimal) and negative numbers 7777777777 to 4000000000 (representing -1 to -229 decimal).
numdigits is an optional number specifying the number of digits to return.
If octalnumber is negative, OCT2HEX returns ten octal digits, representing the octal number in twos complement form.

Example:

OCT2HEX("35")

returns 1D as text.

OCT2HEX(35)

returns 1D as text. The number 35 is read as octal, even though it is not.

OCT2HEX("35"; 4)

returns 001D as text. OCT2HEX adds leading zeroes to make 4 digits.

OCT2HEX("7777777776")

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


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