Documentation/Calc Functions/OCT2DEC

Function name:
OCT2DEC

Category:
Add-in

Summary:
Converts an octal number (base-8) to its decimal (base-10) equivalent. The input octal number must correspond to a decimal number d in the range -229 ≤ d < 229.

Syntax:
OCT2DEC(Number)

Returns:
Returns an integer number in the range -229 ≤ d < 229, which is the decimal value that corresponds to the specified octal number.

Arguments:
Number is a string or a number, or a reference to a cell containing one of those types, which gives the octal number that is to be converted to decimal. The octal number must comprise only the digits 0...7, and must be no more than 10 digits long.


 * Number should use the standard two's complement representation, so that positive numbers are octal 0 to 3777777777 (0 to 229-1 decimal) and negative numbers are octal 7777777777 to 4000000000 (-1 to -229 decimal). Negative numbers must be 10 digits long with the leftmost bit set to 1; positive numbers can comprise less than 10 digits.
 * If Number does not specify a valid octal number, then OCT2DEC reports an invalid argument error (Err:502). This may arise, for example, if Number contains more than 10 characters or if it contains any character other than the digits 0...7.
 * If Number is a string comprising no characters, or a reference to an empty cell, OCT2DEC returns 0.
 * Although the content of Number appears to be decimal, OCT2DEC will interpret it correctly.

Additional details:
The following Wikipedia pages provide useful background information that is relevant to this function:
 * Octal
 * Two's complement

Related LibreOffice functions:
OCT2BIN

OCT2HEX

ODF standard:
Section 6.19.15, part 2

Equivalent Excel functions:
OCT2DEC