Types

Numbers, text, boolean and error values are supported as cell values as well as formulas which also accept Arrays, References, Blank and Missing values. Values of one type may be converted to values of another type automatically within formulas. Blanks and missing arguments may be converted to empty strings, zero, false and also any of the exceptional numeric values. Sum types that combine these data types are supported and include references to user defined functions.

type	enum	description
number	1	64-bit floating point
text	2	unicode text string
bool	4	true or false
ref	8	rectangular, multi-area or external reference
error	16	any error value
flow	32	macrosheet execution control (deprecated)
array	64	array of up to 2^20 rows or columns containing any value types
missing	128	missing argument
nil	256	blank cell
sref	512	single area reference
int	1024	32-bit integer