Package org.apache.poi.ss.formula.eval

Class ErrorEval

java.lang.Object
org.apache.poi.ss.formula.eval.ErrorEval
All Implemented Interfaces:
ValueEval
public final class ErrorEval extends Object implements ValueEval
Evaluations for formula errors

  • Field Details

    • NULL_INTERSECTION

      public static final ErrorEval NULL_INTERSECTION
      #NULL! - Intersection of two cell ranges is empty

    • DIV_ZERO

      public static final ErrorEval DIV_ZERO
      #DIV/0! - Division by zero

    • VALUE_INVALID

      public static final ErrorEval VALUE_INVALID
      #VALUE! - Wrong type of operand

    • REF_INVALID

      public static final ErrorEval REF_INVALID
      #REF! - Illegal or deleted cell reference

    • NAME_INVALID

      public static final ErrorEval NAME_INVALID
      #NAME? - Wrong function or range name

    • NUM_ERROR

      public static final ErrorEval NUM_ERROR
      #NUM! - Value range overflow

    • NA

      public static final ErrorEval NA
      #N/A - Argument or function not available

    • FUNCTION_NOT_IMPLEMENTED

      public static final ErrorEval FUNCTION_NOT_IMPLEMENTED

    • CIRCULAR_REF_ERROR

      public static final ErrorEval CIRCULAR_REF_ERROR

  • Method Details

    • valueOf

      public static ErrorEval valueOf(int errorCode)
      Translates an Excel internal error code into the corresponding POI ErrorEval instance
      Parameters:
      errorCode - An error code listed in FormulaError
      Throws:
      RuntimeException - If an unknown errorCode is specified

    • getText

      public static String getText(int errorCode)
      Converts error codes to text. Handles non-standard error codes OK. For debug/test purposes (and for formatting error messages).
      Returns:
      the String representation of the specified Excel error code.

    • getErrorCode

      public int getErrorCode()

    • getErrorString

      public String getErrorString()

    • toString

      public String toString()
      Overrides:
      toString in class Object