Share via

2.6.96 CT_PivotTableUISettings

  • Article

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

Attributes:

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

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

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

 <xsd:complexType name="CT_PivotTableUISettings">
   <xsd:sequence>
     <xsd:element name="activeTabTopLevelEntity" type="CT_FieldListActiveTabTopLevelEntity" minOccurs="0" maxOccurs="unbounded"/>
     <xsd:element name="extLst" type="x:CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
   </xsd:sequence>
   <xsd:attribute name="sourceDataName" type="xsd:string" use="optional"/>
   <xsd:attribute name="relNeededHidden" type="xsd:boolean" use="optional" default="false"/>
 </xsd:complexType>

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