Enum FormulaError

  • All Implemented Interfaces:
    java.io.Serializable, java.lang.Comparable<FormulaError>

    public enum FormulaError
    extends java.lang.Enum<FormulaError>
    Enumerates error values in SpreadsheetML formula calculations. See also OOO's excelfileformat.pdf (2.5.6)
    • Enum Constant Summary

      Enum Constants 
      Enum Constant Description
      _NO_ERROR  
      CIRCULAR_REF
      POI specific code to indicate that there is a circular reference in the formula
      DIV0
      Intended to indicate when any number, including zero, is divided by zero.
      FUNCTION_NOT_IMPLEMENTED
      POI specific code to indicate that the funcition required is not implemented in POI
      NA
      Intended to indicate when a designated value is not available.
      NAME
      Intended to indicate when what looks like a name is used, but no such name has been defined.
      NULL
      Intended to indicate when two areas are required to intersect, but do not.
      NUM
      Intended to indicate when an argument to a function has a compatible type, but has a value that is outside the domain over which that function is defined.
      REF
      Intended to indicate when a cell reference is invalid.
      VALUE
      Intended to indicate when an incompatible type argument is passed to a function, or an incompatible type operand is used with an operator.