Difference between revisions of "Documentation/How Tos/Calc: Number Conversion functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (Talk | contribs) |
m |
||
| (8 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | {{Documentation/ | + | {{Documentation/CalcFunc Number ConvTOC |
| − | |bookid= | + | |ShowPrevPage={{{ShowPrevPage}}} |
| − | |booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div> | + | |PrevPage={{{PrevPage}}} |
| − | |ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Number_Conversion_functions|<div style="font-size: 140%;">Number Conversion Functions]] | + | |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> | |toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div> | ||
| + | }}__NOTOC__ | ||
| − | + | [[File:open.jpg]] | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | ==List of Calc Number Conversion functions== | + | == <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. | 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. | ||
| Line 98: | Line 86: | ||
<!-- 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: DOLLAR function|DOLLAR]], [[Documentation/How_Tos/Calc: VALUE function|VALUE]] <br> in [[Documentation/How_Tos/Calc: Text functions|Text functions]] | ||
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
-
