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

IgnoredErrorType

Enum Class IgnoredErrorType

java.lang.Object
java.lang.Enum<IgnoredErrorType>
com.grapecity.documents.excel.IgnoredErrorType
All Implemented Interfaces:
Serializable, Comparable<IgnoredErrorType>, Constable
public enum IgnoredErrorType extends Enum<IgnoredErrorType>
The types of errors that can occur in cell.

  • Enum Constant Details

    • InconsistentListFormula

      public static final IgnoredErrorType InconsistentListFormula
      Ignore the error of discrepancies in formulas within a calculated column.

    • InconsistentFormula

      public static final IgnoredErrorType InconsistentFormula
      Ignore the error of discrepancies in formulas within a range.

    • OmittedCells

      public static final IgnoredErrorType OmittedCells
      Ignore the error in cells containing formulas referring to a range that omits adjacent cells that could be included.

    • TextDate

      public static final IgnoredErrorType TextDate
      Ignore the error when formulas contain text formatted cells with years misinterpreted as the wrong century.

    • EmptyCellReferences

      public static final IgnoredErrorType EmptyCellReferences
      Ignore the error when formula contains a reference to an empty cell.

    • ListDataValidation

      public static final IgnoredErrorType ListDataValidation
      Ignore the error of cell value that does not comply with the Data Validation rule that restricts data to predefined items in a list.

    • EvaluateToError

      public static final IgnoredErrorType EvaluateToError
      Ignore the error of the formula result error.
      Formula result error types include #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!.

    • NumberAsText

      public static final IgnoredErrorType NumberAsText
      Ignore the error in cells containing numbers stored as text or preceded by an apostrophe.

    • UnlockedFormulaCells

      public static final IgnoredErrorType UnlockedFormulaCells
      Ignore the error in unlocked cells containing formulas.

  • Method Details

    • values

      public static IgnoredErrorType[] 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 IgnoredErrorType 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