2.2.5.1 Error

  • 2 minutes to read

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

This simple type is defined as follows.

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

The following table specifies the allowable values for Error:

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 empty intersection of two areas.

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.