Share via

2.6.156 CT_PivotTableDefinition16

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2016/pivotdefaultlayout

Referenced by: pivotTableDefinition16

This element specifies additional properties of a PivotTable ([ISO/IEC29500-1:2016] section 18.10) view.

Attributes:

EnabledSubtotalsDefault: A boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether subtotals are enabled by default for the PivotTable.

SubtotalsOnTopDefault: A boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether enabled subtotals are on the top of the PivotTable by default.

InsertBlankRowDefault: A boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether blank rows are inserted into the PivotTable by default.

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

 <xsd:complexType name="CT_PivotTableDefinition16">
   <xsd:attribute name="EnabledSubtotalsDefault" type="xsd:boolean" use="optional" default="true"/>
   <xsd:attribute name="SubtotalsOnTopDefault" type="xsd:boolean" use="optional" default="true"/>
   <xsd:attribute name="InsertBlankRowDefault" type="xsd:boolean" use="optional" default="false"/>
 </xsd:complexType>

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