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

1580.1.1CT_SlicerStyle

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:2012] 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] 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:2012] section 12.3.20. This string MUST match the name attribute of a CT_TableStyle element, as specified in [ISO/IEC29500-4:2012] 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] section 2.1) fragment specifies the contents of this complex type.

1581

1582

1583

1584

1585

1586

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

1586.1.1CT_SlicerStyleElement

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

Referenced by: CT_SlicerStyleElements

A complex type that specifies a table style element, as specified in [ISO/IEC29500-1:2012] section 18.8, of a slicer style, as specified in section 2.3.2.4.

Attributes:

type: An ST_SlicerStyleType attribute, as specified in section 2.7.13, that specifies the type of the table style element. This attribute MUST be unique within the parent CT_SlicerStyleElements complex type.

dxfId: An ST_DxfId attribute, as specified in [ISO/IEC29500-1:2012] section 18.18.25, that specifies a zero-based index for the list of elements specified by the dxfs global element, as specified in section 2.4.24. The specified CT_Dxf complex type, as specified in [ISO/IEC29500-4:2012] section A.2, specifies the formatting to use with this table style element.

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

1587

1588

1589

1590

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

1590.1.1CT_OleItem

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

Referenced by: oleItem

OleItem is a complex type that specifies an OLE data item, as specified in [ISO/IEC29500-1:2012] section 18.14, with associated cached values.

Child Elements:

values: A CT_DdeValues element, as specified in [ISO/IEC29500-4:2012] section A.2, that specifies the cached values.

Attributes:

name: An ST_Xstring attribute, as specified in [ISO/IEC29500-1:2012] section 22.9.2.19, that specifies the name of the OLE data item.

icon: A Boolean attribute, as specified in [XMLSCHEMA2] section 3.2.2, that specifies whether the OLE data item is represented as an icon.

Value	Meaning
"false"	The OLE data item is not represented as an icon.
"true"	The OLE data item is represented as an icon.

advise: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the application requests that the OLE data source, as specified in [ISO/IEC29500-1:2012] section 18.14, provides notifications when the source data changes.

Value	Meaning
"false"	The application does not request to be notified when the source data changes.
"true"	The application requests to be notified when the source data changes.

preferPic: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the OLE data item is an image.

Value	Meaning
"false"	The OLE data item is not an image.
"true"	The OLE data item is an image.

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

1591

1592

1593

1594

1595

1596

1597

1598

1599

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