Share via

2.7.26 ST_SXVCellType

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

Referenced by: CT_PivotValueCell

A simple type that specifies the type of a PivotValueCell element of a PivotTable ([ISO/IEC29500-1:2016] section 18.10) that is specified by a pivotTableReference element in the extension of a workbook.

Value

Meaning

b

The child element v of the CT_PivotValueCell. MUST be interpreted as a Boolean value. MUST be true or false.

n

The child element v of the CT_PivotValueCell. MUST be interpreted as a numeric value.

e

The child element v of the CT_PivotValueCell. MUST be interpreted as an error value. MUST be one of the following:

  • #DIV/0!

  • #VALUE!

  • #NUM!

  • #N/A

  • #GETTING_DATA

str

The child element v of the CT_PivotValueCell. MUST be interpreted as a string value. The string MUST be less than or equal to 65,535 characters in length.

d

The child element v of the CT_PivotValueCell. MUST be interpreted as a dateTime ([XMLSCHEMA2/2] section 3.2.7) value.

bl

A blank cell. The child element v of the CT_PivotValueCell. MUST NOT have any value.

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

 <xsd:simpleType name="ST_SXVCellType">
   <xsd:restriction base="xsd:string">
     <xsd:enumeration value="b"/>
     <xsd:enumeration value="n"/>
     <xsd:enumeration value="e"/>
     <xsd:enumeration value="str"/>
     <xsd:enumeration value="d"/>
     <xsd:enumeration value="bl"/>
   </xsd:restriction>
 </xsd:simpleType>

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