[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format
Yüklə 3,69 Mb.
|
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:2011] 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:2011] 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. See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1). 2.6.46 CT_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:2011] section 18.14, with associated cached values. Child Elements: values: A CT_DdeValues element, as specified in [ISO/IEC29500-4:2011] section A.2, that specifies the cached values. Attributes: name: An ST_Xstring attribute, as specified in [ISO/IEC29500-1:2011] 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.
advise: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the application requests that the OLE data source (1), as specified in [ISO/IEC29500-1:2011] section 18.14, provides notifications when the source data changes.
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: defaultSlicerStyle: A string ([XMLSCHEMA2] section 3.2.1) attribute that specifies the name of the default slicer style to apply to slicers. The length of the string MUST be greater than or equal to 1 character and less than or equal to 255 characters. 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.52 CT_SlicerStyleElements
A complex type that specifies the list of table style ([ISO/IEC29500-1:2011] section 18.8) elements of a slicer style that are specific to slicers. Child Elements: slicerStyleElement: A CT_SlicerStyleElement element that specifies a table style ([ISO/IEC29500-1:2011] section 18.8) element of a slicer style that is specific to slicers. 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.53 CT_IgnoredErrors
A complex type that specifies a list of cell ranges and the types of cell errors that are to be ignored for each of those specific cell ranges. Child Elements: ignoredError: A CT_IgnoredError element that specifies the types of cell errors that are to be ignored for a specific cell range. extLst: A CT_ExtensionList ([ISO/IEC29500-4:2011] section A.2) element that specifies future extensibility for 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.54 CT_IgnoredError
A complex type that specifies the types of cell errors that are to be ignored for a specific cell range. This complex type is equivalent to CT_IgnoredError ([ISO/IEC29500-1:2011] section 18.3.1.50), but allows the sqref child element to have greater than or equal to 8,192 ref child elements. Child Elements: xm:sqref: A sqref element that specifies the range where cell errors have been ignored. This sqref MUST have greater than or equal to 8,192 ref child elements. Attributes: evalError: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to ignore calculation errors.
twoDigitTextYear: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to ignore errors arising from the formatting of date/time values.
Yüklə 3,69 Mb. Dostları ilə paylaş:
|