[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format
Yüklə 3,69 Mb.
|
- Bu səhifədəki naviqasiya:
- Built-in slicer style names
- 2.6.70 CT_SlicerCacheDefinition
- CT_CacheField
- CT_CacheHierarchy
- 2.6.71 CT_SlicerCacheData
- 2.6.72 CT_SlicerCachePivotTables
- 2.6.73 CT_SlicerCachePivotTable
style: An ST_Xstring ([ISO/IEC29500-1:2011] section 22.9.2.19) attribute that specifies the slicer style of the slicer view. If this field (1) 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:
lockedPosition: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the slicer view is locked.
rowHeight: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the row (2) 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. See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1). 2.6.69 CT_Slicer
This complex type specifies which slicer view is associated with this drawing element. Child Elements: extLst: A CT_OfficeArtExtensionList ([ISO/IEC29500-4:2011] section A.4.1) element that specifies future extensibility for this element. Attributes: name: A string ([XMLSCHEMA2] section 3.2.1) attribute that specifies the name of the slicer view that is associated with this drawing element. The value of this attribute MUST match the value of the name attribute of a slicer element within the CT_Slicers element for the current worksheet. The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type. See section 5.2 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1). 2.6.70 CT_SlicerCacheDefinition
A complex type that specifies a slicer cache. Child Elements: pivotTables: A CT_SlicerCachePivotTables element (section 2.6.72) that specifies a group of CT_SlicerCachePivotTable elements (section 2.6.73) that specify the PivotTable ([ISO/IEC29500-1:2011] section 18.10) views that are filtered by the slicer cache (section 2.1.4). data: A CT_SlicerCacheData element (section 2.6.71) that specifies a data source (1) for the slicer cache. extLst: A CT_ExtensionList element, as specified in [ISO/IEC29500-4:2011] section A.2, that specifies future extensibility for this element. Attributes: name: An ST_Xstring ([ISO/IEC29500-1:2011] section 22.9.2.19) attribute that specifies the name of the slicer cache. MUST adhere to the name production rule provided in section 2.2.2. MUST be a unique case-insensitive name within the scope of defined names. sourceName: An ST_Xstring attribute that specifies the MDX unique name or PivotTable ([ISO/IEC29500-1:2011] section 18.10) cache field (1) of the associated PivotTable PivotCache used by the slicer cache. If the slicer source data (section 2.3.2.1.1)is a non-OLAP data source (1), the value of this attribute MUST be equal to the name attribute of a CT_CacheField ([ISO/IEC29500-4:2011] section A.2) element in the list of cache fields, as specified in section 2.3.2.1.2, and specify a PivotTable cache field. The specified CT_CacheField MUST have a serverField attribute equal to "false". The includeNewItemsInFilter attributes of the CT_PivotField ([ISO/IEC29500-4:2011] section A.2) elements of all included CT_CacheField elements MUST be equal. If the slicer source data is an OLAP data source (1), the value MUST be equal to the value of the uniqueName attribute in one of the CT_CacheHierarchy ([ISO/IEC29500-4:2011] section A.2) elements within the associated OLAP pivot cache, as specified in section 2.3.2.1.4, and specify a MDX unique name. The following attributes of the CT_CacheHierarchy element MUST be "false": measure, set, and measures. The CT_PivotHierarchy ([ISO/IEC29500-4:2011] section A.2) element with a zero-based index in the list of CT_PivotHierarchy elements specified by the CT_PivotHierarchies ([ISO/IEC29500-4:2011] section A.2) equal to the zero-based index of the CT_CacheHierarchy element in the list of CT_CacheHierarchy elements specified by CT_CacheHierarchies ([ISO/IEC29500-4:2011] section A.2) MUST have an includeNewItemsInFilter attribute equal to "false". The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type. See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1). 2.6.71 CT_SlicerCacheData
A complex type that specifies a data source (1) for the slicer cache. Child Elements: olap: A CT_OlapSlicerCache element that specifies an OLAP data source (1). tabular: A CT_TabularSlicerCache element that specifies a non-OLAP data source (1). The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type. See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1). 2.6.72 CT_SlicerCachePivotTables
A complex type that specifies a group of CT_SlicerCachePivotTable elements that specify the PivotTable ([ISO/IEC29500-1:2011] section 18.10) views that are filtered by the slicer cache. Child Elements: pivotTable: A CT_SlicerCachePivotTable element that specifies the PivotTable ([ISO/IEC29500-1:2011] section 18.10) view that is filtered. The list of pivotTable child elements MUST NOT contain duplicates. The showCalcMbrs attribute of all CT_PivotTableDefinition ([ISO/IEC29500-4:2011] section A.2) elements associated with PivotTables ([ISO/IEC29500-1:2011] section 18.10) that are specified by pivotTable child elements MUST have the same value. The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type. See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1). 2.6.73 CT_SlicerCachePivotTable
A complex type that specifies a PivotTable ([ISO/IEC29500-1:2011] section 18.10) view filtered by a slicer cache. Attributes: Yüklə 3,69 Mb. Dostları ilə paylaş:
|