<ST_CalcMode> (Calculation Mode)

This simple type defines the supported modes for performing calculations on workbook data.

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

<auto> (Automatic)

Indicates that calculations in the workbook will be performed automatically when cell values change. The application recalculates those cells that are dependent on other cells that contain changed values. This type of calculation helps to avoid unnecessary calculations.

<autoNoTable> (Automatic Calculation (No Tables))

Indicates tables be excluded during automatic calculation.

<manual> (Manual Calculation Mode)

Indicates that calculations in the workbook be triggered manually by the user. For example, the application might expose a command in the user interface.

Referenced By

<calcPr@calcMode> (§3.2.2)

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

<simpleType name="ST_CalcMode">
	<restriction base="xsd:string">
	<enumeration value="manual"/>
	<enumeration value="auto"/>
	<enumeration value="autoNoTable"/>
	</restriction>
</simpleType>