[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format



Yüklə 3,69 Mb.
səhifə22/180
tarix09.01.2022
ölçüsü3,69 Mb.
#95757
1   ...   18   19   20   21   22   23   24   25   ...   180
Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

A slicers element is a CT_Slicers type element, as specified in section 2.6.67, that specifies all the slicer views, as specified in section 2.3.2.2, on the sheet (1). This element is the root element of the slicers part, as specified in section 2.3.2.

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

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

2.4.37 slicer

Target namespace: http://schemas.microsoft.com/office/drawing/2010/slicer

A slicer element is a CT_Slicer type element, as specified in section 2.6.69, that specifies which slicer view, as specified in section 2.3.2.2, is associated with this drawing element. See section 2.2.4.2 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC29500-1:2011].

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

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

2.4.38 slicerCacheDefinition

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

A slicerCacheDefinition element is a CT_SlicerCacheDefinition type element, as specified in section 2.6.70, that specifies a slicer cache, as specified in section 2.3.2.1. This element is the root element of the slicer cache part.

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

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

2.4.39 pivotCaches

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

A pivotCaches element is a CT_PivotCaches element, as specified in [ISO/IEC29500-4:2011] section A.2 that specifies a list of PivotTable, as specified in [ISO/IEC29500-1:2011] section 18.10, PivotCache identifier elements. The list of elements specifies the PivotTable PivotCaches. See section 2.2.4.10 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC29500-1:2011]. The pivotCacheDefinition ([ISO/IEC29500-1:2011] section 18.10.1.67) element identified by the relationship identifier in the CT_PivotCache ([ISO/IEC29500-4:2011] section A.2) child element of this element, MUST satisfy the following criteria.



     There MUST be a CT_PivotCacheIdVersion element in the extension of the element pivotCacheDefinition.

     The type attribute of the CT_CacheSource ([ISO/IEC29500-4:2011] section A.2) child element of the element pivotCacheDefinition, MUST have the value external specified by ST_SourceType ([ISO/IEC29500-1:2011] 18.18.75).



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

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

2.4.40 pivotTableReferences

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

A pivotTableReferences element is a CT_PivotTableReferences element, as specified in section 2.6.86, that specifies a list of PivotTable ([ISO/IEC29500-1:2011] section 18.10) part identifiers for the workbook. See section 2.2.4.10 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC29500-1:2011].

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

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

2.4.41 queryTable


Yüklə 3,69 Mb.

Dostları ilə paylaş:
1   ...   18   19   20   21   22   23   24   25   ...   180




Verilənlər bazası müəlliflik hüququ ilə müdafiə olunur ©muhaz.org 2024
rəhbərliyinə müraciət

gir | qeydiyyatdan keç
    Ana səhifə


yükləyin