Documentation/Calc Functions/TYPE

Function name:
TYPE

Category:
Information

Summary:
Returns a numeric value indicating the type of the supplied argument.

Syntax:
TYPE(Value)

Returns:
Returns a number in accordance with the following table:

Arguments:
Value is an expression, or a reference to a cell containing that expression, whose type is determined.


 * If the argument is a reference to a cell that contains both an error and a formula, the value 16 is returned.
 * If the argument is a reference to an empty cell, the value 1 is returned.

Additional details:

 * Calc uses the return value 8 to indicate a formula cell. This value is not mandated in the function’s description in ODF 1.2 and is not used by Microsoft Excel, which returns the type of the formula's returned value.


 * According to Microsoft's web page for the TYPE function, Excel uses the return value 128, which is not mandated in the function's description in ODF 1.2.


 * As a result of these different behaviors, care should be taken if interoperability between Calc and Excel is important for your spreadsheet.

Related LibreOffice functions:
ERROR.TYPE

ODF standard:
Section 6.13.33, part 2

Equivalent Excel functions:
TYPE