[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

ST_Scope (Conditional Formatting Scope)

This simple type defines the scope of conditional formatting applied in the PivotTable.

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

data (Data Fields)

Indicates that conditional formatting is applied to the selected data fields.

field (Field Intersections)

Indicates that conditional formatting is applied to the selected PivotTable field intersections.

selection (Selection)

Indicates that conditional formatting is applied to the selected cells.

 

Referenced By

conditionalFormat@scope3.10.1.18)

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

<simpleType name="ST_Scope">

   <restriction base="xsd:string">

   <enumeration value="selection"/>

   <enumeration value="data"/>

   <enumeration value="field"/>

   </restriction>

</simpleType>