Package io.keikai.model

Class ErrorValue

java.lang.Object
io.keikai.model.ErrorValue
All Implemented Interfaces:
Serializable
public class ErrorValue extends Object implements Serializable
An error result of a evaluated formula.
Since:
3.5.0
Author:
dennis
See Also:

  • Field Details

    • ERROR_NULL

      public static final byte ERROR_NULL
      #NULL! - Intersection of two cell ranges is empty
      See Also:

    • ERROR_DIV_0

      public static final byte ERROR_DIV_0
      #DIV/0! - Division by zero
      See Also:

    • INVALID_VALUE

      public static final byte INVALID_VALUE
      #VALUE! - Wrong type of operand
      See Also:

    • ERROR_REF

      public static final byte ERROR_REF
      #REF! - Illegal or deleted cell reference
      See Also:

    • INVALID_NAME

      public static final byte INVALID_NAME
      #NAME? - Wrong function or range name
      See Also:

    • ERROR_NUM

      public static final byte ERROR_NUM
      #NUM! - Value range overflow
      See Also:

    • ERROR_NA

      public static final byte ERROR_NA
      #N/A - Argument or function not available
      See Also:

    • ERROR_SPILL

      public static final byte ERROR_SPILL
      #SPILL! - Excel 365 dynamic array spill range blocked or out of range
      See Also:

    • ERROR_CALC

      public static final byte ERROR_CALC
      #CALC! - Excel 365 calculation error (empty/nested arrays, unsupported array ops)
      See Also:

    • INVALID_FORMULA

      public static final byte INVALID_FORMULA
      See Also:

    • NULL

      public static final ErrorValue NULL

    • DIV0

      public static final ErrorValue DIV0

    • VALUE

      public static final ErrorValue VALUE

    • REF

      public static final ErrorValue REF

    • NAME

      public static final ErrorValue NAME

    • NUM

      public static final ErrorValue NUM

    • NA

      public static final ErrorValue NA

    • SPILL

      public static final ErrorValue SPILL

    • CALC

      public static final ErrorValue CALC

    • FORMULA

      public static final ErrorValue FORMULA

  • Constructor Details

    • ErrorValue

      public ErrorValue(byte code)

    • ErrorValue

      public ErrorValue(byte code, String message)

  • Method Details

    • valueOf

      public static ErrorValue valueOf(byte code)

    • getCode

      public byte getCode()

    • setCode

      public void setCode(byte code)
      Set error code.
      Parameters:
      code - should be one of public byte constant in this class

    • getMessage

      public String getMessage()

    • setMessage

      public void setMessage(String message)

    • getErrorString

      public String getErrorString()
      Returns:
      might be #NULL!, #NAME?, or #NUM! etc...

    • toString

      public String toString()
      Overrides:
      toString in class Object

    • getErrorString

      public static final String getErrorString(int errorCode)