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

Class ErrorEval

  • All Implemented Interfaces:
    ValueEval
    public final class ErrorEval
extends Object
implements ValueEval
    Evaluations for formula errors

    • Field Detail

      • 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 Detail

      • 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:
        IllegalStateException - 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()