Share via

2.7.11 ST_PivotEditValueType

  • Article

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

Referenced by: CT_PivotEditValue

A simple type that specifies the type of the modified value in the PivotTable ([ISO/IEC29500-1:2016] section 18.10) data area using PivotTable what-if analysis.

Value

Meaning

number

Numerical value

dateTime

Date and time value

string

String value

boolean

Boolean value

error

Error value

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

 <xsd:simpleType name="ST_PivotEditValueType">
   <xsd:restriction base="xsd:string">
     <xsd:enumeration value="number"/>
     <xsd:enumeration value="dateTime"/>
     <xsd:enumeration value="string"/>
     <xsd:enumeration value="boolean"/>
     <xsd:enumeration value="error"/>
   </xsd:restriction>
 </xsd:simpleType>

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