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

From Apache OpenOffice Wiki
Jump to: navigation, search
m
 
Line 1: Line 1:
{{Documentation/MasterTOC
+
{{DISPLAYTITLE:HEX2BIN function}}
|bookid=1234'''
+
{{Documentation/CalcFunc Number ConvTOC
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div>
+
|ShowPrevNext=block
|ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Number_Conversion_functions|<div style="font-size: 140%;">Number Conversion Functions]]
+
|PrevPage=Documentation/How_Tos/Calc:_DEC2OCT_function
|ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_HEX2DEC_function
+
|NextPage=Documentation/How_Tos/Calc:_HEX2DEC_function
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_DEC2OCT_function
+
}}__NOTOC__
|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%; border-style: double; border-color:#778899;">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%;">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__
+
  
 
== HEX2BIN ==
 
== HEX2BIN ==
Line 34: Line 13:
 
=== Syntax: ===
 
=== Syntax: ===
 
<tt>'''HEX2BIN(hexadecimalnumber; numdigits)'''</tt>
 
<tt>'''HEX2BIN(hexadecimalnumber; numdigits)'''</tt>
: returns text representing a binary number, given <tt>'''hexadecimalnumber'''</tt>, which may be text, or a number (taken to be hexadecimal although it is not).
+
: returns text representing a binary number, given <tt>'''hexadecimalnumber'''</tt>, which may be text, or a number (taken to be hexadecimal, although it is not).
  
 
: The binary number returned 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).
 
: The binary number returned 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).

Latest revision as of 14:18, 1 February 2024

HEX2BIN

Converts a hexadecimal number to binary.

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

Syntax:

HEX2BIN(hexadecimalnumber; numdigits)

returns text representing a binary number, given hexadecimalnumber, which may be text, or a number (taken to be hexadecimal, although it is not).
The binary number returned 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).
hexadecimalnumber must therefore also lie in this range, and is given in two's complement form with up to ten digits.
numdigits is an optional number specifying the number of digits to return.

Example:

HEX2BIN("1D")

returns 11101 as text.

HEX2BIN(10)

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

HEX2BIN("2"; 4)

returns 0010 as text. HEX2BIN adds leading zeroes to make 4 digits.

HEX2BIN("FFFFFFFFFE")

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



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