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>