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

Yüklə 3,69 Mb.

səhifə	129/180
tarix	09.01.2022
ölçüsü	3,69 Mb.
	#95757

1 ... 125 126 127 128 129 130 131 132 ... 180

Enumeration Value

dateBetween (Date Between)

dateEqual (Date Equals)

dateNewerThan (Date Newer Than)

dateNewerThanOrEqual (Date Newer Than or Equal To)

dateNotBetween (Date Not Between)

dateNotEqual (Date Does Not Equal)

dateOlderThan (Date Older Than)

dateOlderThanOrEqual (Date Older Than Or Equal)

lastMonth (Last Month)

lastQuarter (Last Quarter)

lastWeek (Last Week)

lastYear (Last Year)

M1 (Dates in January)

M10 (Dates in October)

M11 (Dates in November)

M12 (Dates in December)

M2 (Dates in February)

M3 (Dates in March)

M4 (Dates in April)

M5 (Dates in May)

M6 (Dates in June)

M7 (Dates in July)

M8 (Dates in August)

M9 (Dates in September)

nextMonth (Next Month)

nextQuarter (Next Quarter)

nextWeek (Next Week)

nextYear (Next Year)

percent (Percent)

Q1 (First Quarter)

Q2 (Second Quarter)

Q3 (Third Quarter)

Q4 (Fourth Quarter)

sum (Sum)

thisMonth (This Month)

thisQuarter (This Quarter)

thisWeek (This Week)

thisYear (This Year)

today (Today)

tomorrow (Tomorrow)

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

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

TableUISettings'>2.6.96 CT_PivotTableUISettings

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

Referenced by: pivotTableUISettings

Specifies state for user interface used to construct and manipulate a PivotTable.

Child Elements:

activeTabTopLevelEntity: A CT_FieldListActiveTabTopLevelEntity element that specifies a field that appears in the user’s working set of fields in the PivotTable field list.

extLst: A CT_ExtensionList ([ISO/IEC29500-4:2011] section A.2) element that specifies future extensibility for this element.

Attributes:

sourceDataName: An ST_Xstring ([ISO/IEC29500-1:2011] section 22.9.2.19) attribute that specifies the name of the primary data connection (2) for the PivotTable. See connection ([ISO/IEC29500-1:2011] section 18.13.1)

relNeededHidden: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the user closed the relationship warning for this PivotTable.

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

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

2.6.97 CT_TableSlicerCache

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

Referenced by: tableSlicerCache

A complex type that specifies properties of the slicer cache specific to table slicer items.

Child Elements:

extLst: A CT_ExtensionList ([ISO/IEC29500-4:2011] section A.2) element that specifies future extensibility for this element.

Attributes:

tableId: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the associated Table ([ISO/IEC29500-1:2011] section 18.5.1.2). MUST match id attribute of an existing Table ([ISO/IEC29500-1:2011] section 18.5.1.2) element.

column: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies associated Table Column ([ISO/IEC29500-1:2011] section 18.5.1.3). MUST match id attribute of an existing tableColumn element representing a column in Table specified by the tableId attribute.

sortOrder: An ST_TabularSlicerCacheSortOrder attribute that specifies how the table slicer items are sorted in the slicer view.

customListSort: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether custom lists are used when sorting the table slicer items.

Value	Meaning
"false"	Custom lists are not used when sorting the table slicer items.
"true"	Custom lists are used when sorting the table slicer items.

crossFilter: An ST_SlicerCacheCrossFilter attribute that specifies how the table slicer items that are used in slicer cross filtering are displayed.

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

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

2.6.98 CT_TimelineCacheRefs

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

Referenced by: timelineCacheRefs

A complex type that specifies a list of Timeline cache part identifiers for the workbook. MUST contain fewer than 2³¹ elements.

Child Elements:

timelineCacheRef: A CT_TimelineCacheRef element that specifies a Timeline cache part identifier in this workbook.

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

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

2.6.99 CT_TimelineCacheRef

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

Referenced by: CT_TimelineCacheRefs

A complex type that specifies a Relationship (section 1.4) identifier to a Timeline Cache (section 2.3.5.1) part in this workbook.

Attributes:

r:id: An ST_RelationshipId ([ISO/IEC29500-1:2011] section 22.8.2.1) attribute that specifies a Relationship (section 1.4) identifier to a Timeline Cache (section 2.3.5.1) part in this workbook.

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

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

2.6.100 CT_TimelineRefs

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

Referenced by: timelineRefs

CT_TimelineRefs is a complex type that specifies a list of Timeline (section 2.3.5) part identifiers for the worksheet. MUST contain exactly one Timeline part identifier.

Child Elements:

timelineRef: A CT_TimelineRef element (section 2.6.101) that specifies the Timeline (section 2.3.5) part identifier for the worksheet.

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

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

2.6.101 CT_TimelineRef

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

Referenced by: CT_TimelineRefs

A complex type that specifies a relationship identifier of the part that contains the Timelines in this worksheet.

Attributes:

r:id: An ST_RelationshipId ([ISO/IEC29500-1:2011] section 22.8.2.1) attribute that specifies a relationship identifier of the part that contains the Timelines in this worksheet.

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

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

CT_CacheHierarchy'>2.6.102 CT_CacheHierarchy

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

Referenced by: cacheHierarchy

CT_CacheHierarchy is a complex type which specifies additional properties for an OLAP measure.

Attributes:

aggregatedColumn: An int attribute that specifies the zero-based index of PivotTable cache hierarchy which corresponds to this OLAP measure. The referenced CT_CacheHierarchy ([ISO/IEC29500-4:2011] section A.2) element specifies the PivotTable cache hierarchy that this OLAP measure aggregates. MUST only be specified if the measure attribute of this cache hierarchy is "true". The value MUST match the index of an existing cache hierarchy in CT_CacheHierarchies ([ISO/IEC29500-4:2011]) collection or be equal -1 if this OLAP measure is not an implicit measure which aggregates a cache hierarchy.

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

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

2.6.103 CT_SlicerCacheHideNoData

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

Referenced by: slicerCacheHideItemsWithNoData

A complex type that specifies the extended properties of a slicer cache, as specified in section 2.3.2.1.

Child Elements:

Yüklə 3,69 Mb.

Dostları ilə paylaş: