[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format Intellectual Property Rights Notice for Open Specifications Documentation

1925.1.1CT_CalculatedMemberExt

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

This element adds an element for supporting new properties for calculated members.

Child Elements:

calculatedMember: A CT_CalculatedMember (section 2.6.93) element that specifies a definition for a custom member or measure that is applied to a pivot table.

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

1926

1927

1928

1929

1930

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

1930.1.1CT_CalculatedMember

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

Referenced by: CT_CalculatedMemberExt, calculatedMember

This element adds new properties for supporting calculated members.

Attributes:

measureGroup: An ST_Xstring ([ISO/IEC29500-1:2012] section 22.9.2.19) attribute that specifies the name of the measure group that this calculated member is associated with if measure is TRUE.

numberFormat: An ST_CalcMemNumberFormat (see section 2.7.25) attribute that specifies the formatting type of the calculated member.

measure: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether this calculated member is also a calculated measure.

Value	Meaning
"true"	This calculated member is also a calculated measure.
"false"	This calculated member is not a calculated measure.

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

1931

1932

1933

1934

1935

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

1935.1.1CT_FieldListActiveTabTopLevelEntity

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

Referenced by: CT_PivotTableUISettings

A complex type which specifies a top level object in the hierarchy of objects displayed in the PivotTable field list.

Attributes:

name: A string ([XMLSCHEMA2] section 3.2.1) attribute that specifies name of the object in the PivotTable field list.

type: An unsignedInt attribute that specifies the type of this top level object. MUST be specified. MUST be one of the values in the following table:

Value	Object Type
0	OLAP Dimension. The name attribute of this element MUST be the MDX unique name of the dimension.
1	Workbook Table. The name attribute of this element MUST be the name of the workbook table.

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

1936

1937

1938

1939

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

1939.1.1CT_PivotFilter

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

Referenced by: pivotFilter

A complex type that specifies the extended properties of a CT_PivotFilter ([ISO/IEC29500-4:2012] section A.2) element.

Attributes:

useWholeDay: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the filter ([ISO/IEC29500-1:2012] section 18.10.1.33) element extended by this type uses whole days in its filtering criteria. MUST be false for filters for which the value of the attribute type ([ISO/IEC29500-1:2012] section 18.10.1.33) is not one of the values mentioned in the table below. MUST be true if the value of the name attribute of the containing CT_PivotTableDefinition ([ISO/IEC29500-4:2012] section A.2) element is equal to the value of the name (section 2.6.114) attribute of at least one CT_ TimelineCachePivotTable (section 2.6.114) element in the Timeline cache (section 2.1.7) and the value of the attribute type of the containing filter element is one of the following.

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.

1940

1941

1942

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