<ST_Type> (Top N Evaluation Type)

This simple type defines the values for the Top N conditional formatting evaluation for the PivotTable. For more information on Top N conditional formatting, see the Sheet (§3.3.1) reference material.

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

<all> (All)

Indicates that Top N conditional formatting is evaluated across the entire scope range.

<column> (Column Top N)

Indicates that Top N conditional formatting is evaluated for each column.

<none> (Top N None)

Indicates that Top N conditional formatting is not evaluated

<row> (Row Top N)

Indicates that Top N conditional formatting is evaluated for each row.

Referenced By

<conditionalFormat@type> (§3.10.1.18)

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

<simpleType name="ST_Type">
	<restriction base="xsd:string">
	<enumeration value="none"/>
	<enumeration value="all"/>
	<enumeration value="row"/>
	<enumeration value="column"/>
	</restriction>
</simpleType>