2.2.5.2 CellError

  • Article

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

The CellError type MUST only be used in a cellValues element of GetRangeValuesResponse (section 3.1.4.16.2.2) and in a cellValues element of GetRangeValuesA1Response (section 3.1.4.17.2.2).

 <s:simpleType name="CellError">
   <s:restriction base="s:string">
     <s:enumeration value="Div0" />
     <s:enumeration value="NotApplicable" />
     <s:enumeration value="Name" />
     <s:enumeration value="Null" />
     <s:enumeration value="Num" />
     <s:enumeration value="Ref" />
     <s:enumeration value="Value" />
   </s:restriction>
 </s:simpleType>

The following table specifies possible values for CellError.

Value

Meaning

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 that is not valid.

Value

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