Share via

2.6.42 CT_PivotEditValue

  • Article

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

Referenced by: CT_PivotUserEdit, CT_PivotChange

A complex type that specifies the value type of the user input in the single cell of the PivotTable, as specified in [ISO/IEC29500-1:2016] section 18.10, data area, or value type of the value that replaces the original value in the OLAP data source for PivotTable what-if analysis, as specified in section 2.3.1.

Attributes:

valueType: An ST_PivotEditValueType attribute, as specified in section 2.7.11, that specifies the type of the value of the user input or the type of the value that replaces the original value in the OLAP data source.

The length of the string MUST be greater than zero and MUST be less than 32,768 characters.

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

 <xsd:complexType name="CT_PivotEditValue">
   <xsd:simpleContent>
     <xsd:extension base="x:ST_Xstring">
       <xsd:attribute name="valueType" use="required" type="ST_PivotEditValueType"/>
     </xsd:extension>
   </xsd:simpleContent>
 </xsd:complexType>

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