3.1.4.34.4.2 CellError

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

The CellError type is an enumeration of a set of cell error values that a worksheet cell can contain.

 <xs:simpleType name="CellError" xmlns:xs="http://www.w3.org/2001/XMLSchema">
   <xs:restriction base="xs:string">
     <xs:enumeration value="None"/>
     <xs:enumeration value="Div0"/>
     <xs:enumeration value="NotApplicable"/>
     <xs:enumeration value="Name"/>
     <xs:enumeration value="Null"/>
     <xs:enumeration value="Num"/>
     <xs:enumeration value="Ref"/>
     <xs:enumeration value="Value"/>
     <xs:enumeration value="GettingData"/>
   </xs:restriction>
 </xs:simpleType>

The following table specifies the allowable values for the CellError simple type.

Value

Meaning

None

Worksheet cell contains a value that does not result in an error.

Div0

Worksheet cell contains a number that is divided by 0.

NotApplicable

Worksheet cell contains a value not available to a formula.

Name

Worksheet cell contains text not recognized by a formula.

Null

Worksheet cell contains an intersection of two areas that do not intersect.

Num

Worksheet cell contains invalid numeric values in a formula.

Ref

Worksheet cell contains a reference (2) that is not valid.

Value

Worksheet cell contains a formula that includes worksheet cells that contain different data types.

GettingData

Worksheet cell contains a value that is still being evaluated.