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

1942.1.1CT_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:2012] section A.2) element that specifies future extensibility for this element.

Attributes:

sourceDataName: An ST_Xstring ([ISO/IEC29500-1:2012] section 22.9.2.19) attribute that specifies the name of the primary data connection for the PivotTable. See connection ([ISO/IEC29500-1:2012] 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.

1943

1944

1945

1946

1947

1948

1949

1950

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

1950.1.1CT_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:2012] 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:2012] section 18.5.1.2). MUST match id attribute of an existing Table ([ISO/IEC29500-1:2012] section 18.5.1.2) element.

column: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies associated Table Column ([ISO/IEC29500-1:2012] 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.

1951

1952

1953

1954

1955

1956

1957

1958

1959

1960

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

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

1961

1962

1963

1964

1965

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

1965.1.1CT_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:2012] 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.

1966

1967

1968

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