2.2.4.16 CellCompoundValue

  • Article

Namespace: http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/

The CellCompoundValue complex type contains the number formatted and the unformatted value of a cell.

The CellCompoundValue type MUST only be used in the elements in the rangeRequests element of GetRangeValuesA1Response (section 3.1.4.24.2.2).

 <xs:complexType name="CellCompoundValue" xmlns:xs="http://www.w3.org/2001/XMLSchema">
   <xs:sequence>
     <xs:element minOccurs="0" maxOccurs="1" name="Value"/>
     <xs:element minOccurs="0" maxOccurs="1" name="Formatted" type="xs:string"/>
   </xs:sequence>
 </xs:complexType>

Value: The unformatted value of a cell. If present MUST be one of the following types:

  • Boolean

  • Double

  • String

  • CellError as specified in section 3.1.4.34.4.2.

Formatted: The number formatted value of the cell. MUST be present.