[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

CalcError

Enum Class CalcError

java.lang.Object
java.lang.Enum<CalcError>
com.grapecity.documents.excel.CalcError
All Implemented Interfaces:
Serializable, Comparable<CalcError>, Constable
public enum CalcError extends Enum<CalcError>
Specifies a calculation error value.

Use this enum when reading or assigning formula error values, such as #DIV/0!, #VALUE!, or #N/A.

  • Nested Class Summary

    Nested classes/interfaces inherited from class java.lang.Enum

    Enum.EnumDesc<E extends Enum<E>>

  • Enum Constant Summary

    Enum Constants
    Enum Constant
    Description
    Blocked
    Indicates that the connection is blocked or prevented from being established.
    Busy
    Indicates that a cell is calculating an async formula.
    Calc
    Occurs when the calculation engine encounters a scenario it does not currently support.
    Connect
    Indicates that the connection is failed or unable to be established.
    Div0
    Occurs when a formula attempts to divide by zero.
    GettingData
    Indicates that an error occurred while retrieving data.
    NA
    Indicates that a value is not available to a formula.
    Name
    Occurs if Excel does not recognise a formula name or does not recognise text within a formula.
    None
    Specifies no error.
    Null
    Occurs when you refer to an intersection of two ranges that do not intersect.
    Num
    Occurs when Excel encounters an invalid number.
    Ref
    Occurs when a formula contains an invalid cell reference.
    Spill
    Indicates that a formula returns multiple results, but can't return these values to neighboring cells.
    Value
    Occurs if one of the variables in your formula is of the wrong type (e.g.

  • Method Summary

    Modifier and Type
    Method
    Description
    static CalcError
    forValue(int value)
    Retrieves the enum constant corresponding to the specified integer value.
    int
    getValue()
    Retrieves the integer value representing the enum constant.
    static CalcError
    valueOf(String name)
    Returns the enum constant of this class with the specified name.
    static CalcError[]
    values()
    Returns an array containing the constants of this enum class, in the order they are declared.

    Methods inherited from class java.lang.Enum

    clone, compareTo, describeConstable, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

    Methods inherited from class java.lang.Object

    getClass, notify, notifyAll, wait, wait, wait

  • Enum Constant Details

    • None

      public static final CalcError None
      Specifies no error.

    • Null

      public static final CalcError Null
      Occurs when you refer to an intersection of two ranges that do not intersect.

    • Div0

      public static final CalcError Div0
      Occurs when a formula attempts to divide by zero.

    • Value

      public static final CalcError Value
      Occurs if one of the variables in your formula is of the wrong type (e.g. text value when a numeric value is expected).

    • Ref

      public static final CalcError Ref
      Occurs when a formula contains an invalid cell reference.

    • Name

      public static final CalcError Name
      Occurs if Excel does not recognise a formula name or does not recognise text within a formula.

    • Num

      public static final CalcError Num
      Occurs when Excel encounters an invalid number.

    • NA

      public static final CalcError NA
      Indicates that a value is not available to a formula.

    • GettingData

      public static final CalcError GettingData
      Indicates that an error occurred while retrieving data.

    • Spill

      public static final CalcError Spill
      Indicates that a formula returns multiple results, but can't return these values to neighboring cells.

    • Calc

      public static final CalcError Calc
      Occurs when the calculation engine encounters a scenario it does not currently support.

    • Busy

      public static final CalcError Busy
      Indicates that a cell is calculating an async formula.

    • Connect

      public static final CalcError Connect
      Indicates that the connection is failed or unable to be established.

    • Blocked

      public static final CalcError Blocked
      Indicates that the connection is blocked or prevented from being established.

  • Method Details

    • values

      public static CalcError[] values()
      Returns an array containing the constants of this enum class, in the order they are declared.
      Returns:
      an array containing the constants of this enum class, in the order they are declared

    • valueOf

      public static CalcError valueOf(String name)
      Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (Extraneous whitespace characters are not permitted.)
      Parameters:
      name - the name of the enum constant to be returned.
      Returns:
      the enum constant with the specified name
      Throws:
      IllegalArgumentException - if this enum class has no constant with the specified name
      NullPointerException - if the argument is null

    • getValue

      public int getValue()
      Retrieves the integer value representing the enum constant.
      Returns:
      The ordinal value of the enum constant.

    • forValue

      public static CalcError forValue(int value)
      Retrieves the enum constant corresponding to the specified integer value.
      Parameters:
      value - The integer value representing the enum constant.
      Returns:
      The CalcError enum constant.