[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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>