2.2.5.2 CellError
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. |