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

1749.1.1CT_DatastoreItem

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

Referenced by: datastoreItem

A complex type that specifies properties for an embedded custom data part.

Child Elements:

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

Attributes:

id: An ST_Xstring attribute, as specified in ([ISO/IEC29500-1:2012] section 22.9.2.19, that specifies the identifier for the associated Custom Data storage. The value of the string is used to identify the associated Custom Data storage, and the value of the string MUST be unique for each Custom Data storage in the workbook. The length of this value MUST be less than 65536 characters.

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

1750

1751

1752

1753

1754

1755

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

1755.1.1CT_Slicers

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

Referenced by: slicers

A complex type that specifies a list of CT_Slicer elements, as specified in section 2.6.69. The list of CT_Slicer elements specifies all slicer views on the worksheet.

Child Elements:

slicer: A CT_Slicer element that specifies a slicer view on the worksheet.

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

1756

1757

1758

1759

1760

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

1760.1.1CT_Slicer

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

Referenced by: CT_Slicers

A complex type that specifies a slicer view, as specified in section 2.3.2.2, in this worksheet.

Child Elements:

extLst: A CT_ExtensionList element, a specified in [ISO/IEC29500-4:2012] section A.2, that specifies future extensibility for this element.

Attributes:

name: An ST_Xstring attribute, as specified in [ISO/IEC29500-1:2012] section 22.9.2.19, that specifies the name of the slicer view. MUST be a unique case-insensitive name within the scope of this workbook. The length of this attribute MUST be greater than or equal to 1 character and MUST be less than or equal to 32767 characters.

xr10:uid: An ST_Guid ([ISO/IEC29500-1:2012] section 22.9.2.4) attribute that specifies the unique id of the slicer view. If any instance of this type specifies this attribute, then all instances MUST specify it, and the values must be distinct.

cache: An ST_Xstring attribute that specifies the name of the slicer cache, as specified in section 2.3.2.1, that this slicer view is associated with. There MUST be a CT_SlicerCacheDefinition element, as specified in section 2.6.70, within this workbook with the name attribute equal to the value of this attribute.

caption: An ST_Xstring attribute that specifies the caption of the slicer view. If this string exists, the length MUST be greater than or equal to 1 character.

startItem: An unsignedInt attribute, as specified in [XMLSCHEMA2] section 3.3.22, that specifies the zero-based index of the first slicer item, as specified in section 2.3.2.1.6, displayed by the slicer view.

columnCount: An unsignedInt attribute that specifies the number of columns in the slicer view. MUST be greater than or equal to 1 and MUST be less than or equal to 20000.

showCaption: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the caption is displayed.

Value	Meaning
"true"	The caption is displayed.
"false"	The caption is suppressed.

level: An unsignedInt attribute that specifies the OLAP level of the OLAP hierarchy of the slicer source data used by this slicer view.

If the slicer source data is OLAP, the value MUST be greater than or equal to 0 and MUST be less than count of the CT_OlapSlicerCacheLevelsData element specified by the CT_SlicerCacheDefinition element specified by cache. If the OLAP hierarchy has an OLAP All level, the value MUST NOT be 0.

If the slicer source data is non-OLAP, this attribute MUST NOT exist.

style: An ST_Xstring ([ISO/IEC29500-1:2012] section 22.9.2.19) attribute that specifies the slicer style of the slicer view. If this field exists, this string MUST match the name attribute of a CT_SlicerStyle element within this workbook or MUST be equal to one of the built-in slicer style names:

Built-in slicer style names
SlicerStyleLight1
SlicerStyleLight2
SlicerStyleLight3
SlicerStyleLight4
SlicerStyleLight5
SlicerStyleLight6
SlicerStyleOther1
SlicerStyleOther2
SlicerStyleDark1
SlicerStyleDark2
SlicerStyleDark3
SlicerStyleDark4
SlicerStyleDark5
SlicerStyleDark6

lockedPosition: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the slicer view is locked.

Value	Meaning
"true"	The slicer view is locked.
"false"	The slicer view is not locked.

rowHeight: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the row height of the slicer view in English Metric Units (EMUs).

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

1761

1762

1763

1764

1765

1766

1767

1768

1769

1770

1771

1772

1773

1774

1775

1776

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