Share via

2.6.44 CT_SlicerStyle

  • Article

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

Referenced by: CT_SlicerStyles

CT_SlicerStyle specifies table style elements, as specified in [ISO/IEC29500-1:2016] section 18.8, of the slicer style, as specified in section 2.3.2.4, that are specific to slicers, as specified in section 2.3.2.

Child Elements:

slicerStyleElements: A CT_SlicerStyleElements, as specified in section 2.6.52, that specifies table style elements of the slicer style that are specific to slicers. There MUST NOT be more than one CT_SlicerStyleElements in this element.

Attributes:

name: A string attribute, as specified in [XMLSCHEMA2/2] section 3.2.1, that specifies the name of the user-defined table style that this slicer style is based upon. The length of the string MUST be greater than or equal to 1 character and less than or equal to 255 characters. This string MUST be unique within the CT SlicerStyle elements in the Styles part, as specified in [ISO/IEC29500-1:2016] section 12.3.20. This string MUST match the name attribute of a CT_TableStyle element, as specified in [ISO/IEC29500-4:2016] section A.2, in the Styles part. In the CT_TableStyle element with a name attribute that matches this string, the pivot attribute MUST equal "false" and the table attribute MUST equal "false".

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

 <xsd:complexType name="CT_SlicerStyle">
   <xsd:sequence>
     <xsd:element name="slicerStyleElements" type="CT_SlicerStyleElements" minOccurs="0" maxOccurs="1"/>
   </xsd:sequence>
   <xsd:attribute name="name" type="xsd:string" use="required"/>
 </xsd:complexType>

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