[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

ST_FormulaExpression (Formula Expression Type)

This simple type specifies an expression type that can comprise a formula.

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

area (Area)

Reference to a range of cells.

areaError (Area Error)

Reference to a range of cells that now evaluates to an error.

computedArea (Computed Area)

Computed area reference.

ref (Reference)

Single cell reference.

refError (Reference Is Error)

Single cell reference that now evaluates to an error.

 

Referenced By

undo@exp3.11.1.25)

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

<simpleType name="ST_FormulaExpression">

   <restriction base="xsd:string">

   <enumeration value="ref"/>

   <enumeration value="refError"/>

   <enumeration value="area"/>

   <enumeration value="areaError"/>

   <enumeration value="computedArea"/>

   </restriction>

</simpleType>