<ST_CellFormulaType> (Formula Type)

Indicates the type of formula in the cell.

This simple type's contents are a restriction of the XML Schema string datatype.

The following are possible enumeration values for this type:

Enumeration Value


<array> (Array Entered)

Formula is an array entered formula.

<dataTable> (Table Formula)

Formula is a data table formula.

<normal> (Normal)

Formula is a regular cell formula.

<shared> (Shared Formula)

Formula is part of a shared formula.

The following XML Schema fragment defines the contents of this simple type:

<simpleType name="ST_CellFormulaType">
	<restriction base="xsd:string">
	<enumeration value="normal"/>
	<enumeration value="array"/>
	<enumeration value="dataTable"/>
	<enumeration value="shared"/>