[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format
Yüklə 3,69 Mb.
|
preferPic: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the OLE data item is an image.
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.47 CT_PivotHierarchy
A complex type that specifies whether the ancestor CT_PivotHierarchy element, as specified in [ISO/IEC29500-4:2011] section A.2, SHOULD<14> be ignored. The ancestor CT_PivotHierarchy element has the following restrictions on attributes.
The ancestor CT_PivotHierarchy element has the following restrictions on child elements.
If this element exists, there MUST exist a CT_DataField element, as specified in [ISO/IEC29500-4:2011] section A.2, with an fld attribute equal to the zero-based index of a CT_CacheField element, as specified in [ISO/IEC29500-4:2011] section A.2, in the list of CT_CacheField elements specified by CT_CacheFields, as specified in [ISO/IEC29500-4:2011] section A.2, with a hierarchy attribute that specifies a CT_CacheHierarchy, as specified in [ISO/IEC29500-4:2011] section A.2, with a zero-based index in the list of CT_CacheHierarchy elements specified by the CT_CacheHierarchies element, as specified in([ISO/IEC29500-4:2011] section A.2, equal to the zero-based index of the ancestor CT_PivotHierarchy element in the list of CT_PivotHierarchy elements specified by CT_PivotHierarchies, as specified in [ISO/IEC29500-4:2011] section A.2. Additionally, that CT_DataField element MUST have a descendant CT_DataField element, as specified in section 2.6.25, with a sourceField attribute specified. For more details, see section 2.6.25. Attributes: ignore: A Boolean attribute, as specified in [XMLSCHEMA2] section 3.2.2, that MUST be "true" and MUST be ignored. 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.48 CT_CacheField
This complex type specifies the ancestor CT_CacheField ([ISO/IEC29500-4:2011] section A.2) element that SHOULD<15> be ignored. The following table lists the restrictions on attributes of the ancestor CT_CacheField element.
The following table lists the restrictions on child elements of the ancestor CT_CacheField element.
If this element exists, there MUST exist a CT_DataField ([ISO/IEC29500-4:2011] section A.2) element with an fld attribute equal to the zero-based index of the ancestor CT_CacheField element in the list of CT_CacheField elements specified by CT_CacheFields ([ISO/IEC29500-4:2011] section A.2). Additionally, that CT_DataField element MUST have a descendant CT_DataField element (section 2.6.25) with a sourceField attribute specified. For more details, see CT_DataField Attributes: ignore: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that MUST be "true" and MUST be ignored. 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.49 CT_ConditionalFormats
This complex type specifies a collection of conditional formats applied to the PivotTable ([ISO/IEC29500-1:2011] section 18.10) view. Child Elements: conditionalFormat: A CT_ConditionalFormat element that specifies the conditional formatting applied to the PivotTable ([ISO/IEC29500-1:2011] section 18.10) view. Attributes: count: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the number of conditionalFormat child elements of this element. 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.50 CT_ConditionalFormat
This complex type specifies the scope, type, and priority of conditional formatting applied to this PivotTable ([ISO/IEC29500-1:2011] section 18.10) view. Child Elements: pivotAreas: A CT_PivotAreas ([ISO/IEC29500-4:2011] section A.2) element that specifies a set of PivotTable areas this conditional formatting applies to. extLst: A CT_ExtensionList ([ISO/IEC29500-4:2011] section A.2) element that specifies future extensibility for this element. Attributes: scope: An ST_Scope ([ISO/IEC29500-1:2011] section 18.18.67) attribute that specifies the scope of this conditional formatting. type: An ST_Type ([ISO/IEC29500-1:2011] section 18.18.84) attribute that MUST NOT be present or MUST be equal to "none". priority: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the priority of the PivotTable conditional formatting. This value MUST be greater than or equal to 1. If this attribute is present, there MUST exist a CT_CfRule with a priority attribute equal to the value of this field (1) and it MUST be the same CT_CfRule element that is specified by id. The CT_CfRule specified by this value MUST have an ancestor CT_ConditionalFormatting element with a pivot attribute equal to "true". id: An ST_Guid ([ISO/IEC29500-1:2011] section 22.9.2.4) attribute that specifies a particular CT_CfRule. There MUST exist a CT_CfRule with an id attribute equal to this value and it MUST be the same CT_CfRule element that is specified by priority. 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.51 CT_SlicerStyles
A complex type that specifies a group of slicer styles and the default slicer style to apply to slicers. Child Elements: slicerStyle: A CT_SlicerStyle element that specifies a slicer style. Attributes: Yüklə 3,69 Mb. Dostları ilə paylaş:
|