[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format Intellectual Property Rights Notice for Open Specifications Documentation

1605.1.1CT_ConditionalFormats

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_PivotTableDefinition

This complex type specifies a collection of conditional formats applied to the PivotTable ([ISO/IEC29500-1:2012] section 18.10) view.

Child Elements:

conditionalFormat: A CT_ConditionalFormat element that specifies the conditional formatting applied to the PivotTable ([ISO/IEC29500-1:2012] section 18.10) view.

Attributes:

count: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the number of conditionalFormat child elements of this element.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

1606

1607

1608

1609

1610

1611

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

1611.1.1CT_ConditionalFormat

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_ConditionalFormats

This complex type specifies the scope, type, and priority of conditional formatting applied to this PivotTable ([ISO/IEC29500-1:2012] section 18.10) view.

Child Elements:

pivotAreas: A CT_PivotAreas ([ISO/IEC29500-4:2012] section A.2) element that specifies a set of PivotTable areas this conditional formatting applies to.

extLst: A CT_ExtensionList ([ISO/IEC29500-4:2012] section A.2) element that specifies future extensibility for this element.

Attributes:

scope: An ST_Scope ([ISO/IEC29500-1:2012] section 18.18.67) attribute that specifies the scope of this conditional formatting.

type: An ST_Type ([ISO/IEC29500-1:2012] section 18.18.84) attribute that MUST NOT be present or MUST be equal to "none".

priority: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the priority of the PivotTable conditional formatting. This value MUST be greater than or equal to 1. If this attribute is present, there MUST exist a CT_CfRule with a priority attribute equal to the value of this field and it MUST be the same CT_CfRule element that is specified by id. The CT_CfRule specified by this value MUST have an ancestor CT_ConditionalFormatting element with a pivot attribute equal to "true".

id: An ST_Guid ([ISO/IEC29500-1:2012] section 22.9.2.4) attribute that specifies a particular CT_CfRule. There MUST exist a CT_CfRule with an id attribute equal to this value and it MUST be the same CT_CfRule element that is specified by priority.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

1612

1613

1614

1615

1616

1617

1618

1619

1620

1621

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

1621.1.1CT_SlicerStyles

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: slicerStyles

A complex type that specifies a group of slicer styles and the default slicer style to apply to slicers.

Child Elements:

slicerStyle: A CT_SlicerStyle element that specifies a slicer style.

Attributes:

defaultSlicerStyle: A string ([XMLSCHEMA2] section 3.2.1) attribute that specifies the name of the default slicer style to apply to slicers. The length of the string MUST be greater than or equal to 1 character and less than or equal to 255 characters.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

1622

1623

1624

1625

1626

1627

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

1627.1.1CT_SlicerStyleElements

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_SlicerStyle

A complex type that specifies the list of table style ([ISO/IEC29500-1:2012] section 18.8) elements of a slicer style that are specific to slicers.

Child Elements:

slicerStyleElement: A CT_SlicerStyleElement element that specifies a table style ([ISO/IEC29500-1:2012] section 18.8) element of a slicer style that is specific to slicers.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

1628

1629

1630

1631

1632

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).