Share via

2.6.41 CT_PivotUserEdit

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_PivotEdit

A complex type that specifies user input, related to PivotTable what-if analysis, in a single cell of the PivotTable ([ISO/IEC29500-1:2016] section 18.10) data area.

Child Elements:

xm:f: An f element that specifies a formula. The formula MUST adhere to the grammar provided in Formulas, with the following restriction: The formula MUST NOT use the bang-reference or bang-name production rules.

editValue: A CT_PivotEditValue element that specifies the user input value that replaces the original cell value, in a single cell of the PivotTable ([ISO/IEC29500-1:2016] section 18.10) data area.

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

 <xsd:complexType name="CT_PivotUserEdit">
   <xsd:choice minOccurs="1" maxOccurs="1">
     <xsd:element ref="xm:f" minOccurs="1" maxOccurs="1"/>
     <xsd:element name="editValue" type="CT_PivotEditValue" minOccurs="1" maxOccurs="1"/>
   </xsd:choice>
 </xsd:complexType>

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