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	Description
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"/>

   </restriction>

</simpleType>