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

autoDelete: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether this connection will be automatically deleted when all data features which use it are deleted.

Value	Meaning
"true"	This connection will be automatically deleted when all data features that use it are deleted.
"false"	This connection will not be automatically deleted when all data features that use it are deleted.

usedByAddin: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether this connection is used by an addin component and will not be deleted with any data feature that uses it.

Value	Meaning
"true"	This connection is used by an addin component.
"false"	This connection is not used by an addin component.

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.92 CT_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.

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

2.6.93 CT_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:2011] 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.

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

2.6.94 CT_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 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.

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

2.6.95 CT_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:2011] section A.2) element.

Attributes:

useWholeDay: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the filter ([ISO/IEC29500-1:2011] 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:2011] 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:2011] 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.