Difference between revisions of "Documentation/How Tos/Calc: Number Conversion functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
m |
||
| (19 intermediate revisions by 6 users not shown) | |||
| Line 1: | Line 1: | ||
| − | == | + | {{Documentation/CalcFunc Number ConvTOC |
| + | |ShowPrevPage={{{ShowPrevPage}}} | ||
| + | |PrevPage={{{PrevPage}}} | ||
| + | |ShowNextPage={{{ShowNextPage}}} | ||
| + | |NextPage={{{NextPage}}} | ||
| + | |bookid=CalcFunctions | ||
| + | |booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">[[Documentation/Reference/Calc_functions|CALC FUNCTIONS]]</div> | ||
| + | |ShowParttitle=block | ||
| + | |parttitle=[[Documentation/How_Tos/Calc:_Number_Conversion_functions|<div style="font-size: 140%;">Number Conversion Functions]] | ||
| + | |toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div> | ||
| + | }}__NOTOC__ | ||
| − | + | [[File:open.jpg]] | |
| + | == <big>List of Calc Number Conversion functions</big> == | ||
| + | |||
| + | The Number Conversion functions convert numbers between forms. Binary, octal and hexadecimal numbers may be represented by text, or by numbers using only valid digits (0-1 for binary, 0-7 for octal); this is only a representation, and arithmetic (eg addition) will not work. Calc functions return text for binary, octal and hexadecimal numbers. | ||
{| border="0" cellpadding="0" cellspacing="10" align="left" | {| border="0" cellpadding="0" cellspacing="10" align="left" | ||
| Line 39: | Line 52: | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: HEX2OCT function|'''HEX2OCT''']] | |[[Documentation/How_Tos/Calc: HEX2OCT function|'''HEX2OCT''']] | ||
| − | |Converts a hexadecimal number to | + | |Converts a hexadecimal number to octal. |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: OCT2BIN function|'''OCT2BIN''']] | |[[Documentation/How_Tos/Calc: OCT2BIN function|'''OCT2BIN''']] | ||
| − | |Converts an octal number to | + | |Converts an octal number to binary. |
|-valign="top" | |-valign="top" | ||
| Line 53: | Line 66: | ||
|Converts an octal number to hexadecimal. | |Converts an octal number to hexadecimal. | ||
| + | |||
| + | |-valign="top" | ||
| + | |[[Documentation/How_Tos/Calc: ARABIC function|'''ARABIC''']] | ||
| + | |returns an Arabic number (eg 14), given a Roman number (eg XIV). | ||
| + | |||
| + | |-valign="top" | ||
| + | |[[Documentation/How_Tos/Calc: BAHTTEXT function|'''BAHTTEXT''']] | ||
| + | |returns Thai text, given a number. | ||
| + | |||
| + | |-valign="top" | ||
| + | |[[Documentation/How_Tos/Calc: DECIMAL function|'''DECIMAL''']] | ||
| + | |returns a decimal number, given a text representation and its base radix. | ||
| + | |||
| + | |-valign="top" | ||
| + | |[[Documentation/How_Tos/Calc: ROMAN function|'''ROMAN''']] | ||
| + | |returns a Roman numeral (eg XIV), given a number. | ||
|} | |} | ||
<br style="clear:both;" /> | <br style="clear:both;" /> | ||
<!-- why on earth is this necessary? --> | <!-- why on earth is this necessary? --> | ||
| − | + | {{SeeAlso|EN| | |
| + | * [[Documentation/How_Tos/Calc: DOLLAR function|DOLLAR]], [[Documentation/How_Tos/Calc: VALUE function|VALUE]] <br> in [[Documentation/How_Tos/Calc: Text functions|Text functions]] | ||
| + | |||
| + | * [[Documentation/How_Tos/Calc: DOLLARDE function|DOLLARDE]], [[Documentation/How_Tos/Calc: DOLLARFR function|DOLLARFR]] <br> in [[Documentation/How_Tos/Calc: Financial functions|Financial 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]] | ||
Latest revision as of 12:07, 27 February 2024
- Number Conversion Functions
- BIN2DECBIN2HEXBIN2OCTDEC2BINDEC2HEXDEC2OCTHEX2BINHEX2DECHEX2OCTOCT2BINOCT2DECOCT2HEXARABIC
List of Calc Number Conversion functions
The Number Conversion functions convert numbers between forms. Binary, octal and hexadecimal numbers may be represented by text, or by numbers using only valid digits (0-1 for binary, 0-7 for octal); this is only a representation, and arithmetic (eg addition) will not work. Calc functions return text for binary, octal and hexadecimal numbers.
BIN2DEC Converts a binary number to decimal. BIN2HEX Converts a binary number to hexadecimal. BIN2OCT Converts a binary number to octal. DEC2BIN Converts a decimal number to binary. DEC2HEX Converts a decimal number to hexadecimal. DEC2OCT Converts a decimal number to octal. HEX2BIN Converts a hexadecimal number to binary. HEX2DEC Converts a hexadecimal number to decimal. HEX2OCT Converts a hexadecimal number to octal. OCT2BIN Converts an octal number to binary. OCT2DEC Converts an octal number to decimal. OCT2HEX Converts an octal number to hexadecimal.
ARABIC returns an Arabic number (eg 14), given a Roman number (eg XIV). BAHTTEXT returns Thai text, given a number. DECIMAL returns a decimal number, given a text representation and its base radix. ROMAN returns a Roman numeral (eg XIV), given a number.
See Also
-
