Documentation/How Tos/Calc: DEC2OCT function
From Apache OpenOffice Wiki
DEC2OCT
Converts a decimal number to octal.
This function is only available if the Analysis AddIn is installed.
Syntax:
DEC2OCT(number; numdigits)
- returns an octal number as text, given the decimal number, which must be between -229 and 229-1 inclusive, and may be text or a number.
- The result is an octal number with up to ten digits in two's complement representation.
- numdigits is an optional number specifying the number of digits to return.
Example:
DEC2OCT(19)
- returns 23 as text.
DEC2OCT("19")
- returns 23 as text. DEC2OCT will accept a decimal number given as text.
DEC2OCT(19; 3)
- returns 023 as text. Leading zeroes are added to make 3 digits.
DEC2OCT(-2)
- returns 7777777776 as text.