asposecells.api

Field Detail

• EVALUATION_ERROR

  const int EVALUATION_ERROR

  Ignore errors when cells contain formulas that result in an error.

• CALC

  const int CALC

  NOTE: This member is now obsolete. Instead, please use ErrorCheckType.EvaluationError enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.

• EMPTY_CELL_REF

  const int EMPTY_CELL_REF

  Ignore errors when formulas refer to empty cells.

• NUMBER_STORED_AS_TEXT

  const int NUMBER_STORED_AS_TEXT

  Ignore errors when numbers are formatted as text or are preceded by an apostrophe

• TEXT_NUMBER

  const int TEXT_NUMBER

  Ignore errors when numbers are formatted as text or are preceded by an apostrophe

  NOTE: This member is now obsolete. Instead, please use ErrorCheckType.NumberStoredAsText enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.

• INCONSIST_RANGE

  const int INCONSIST_RANGE

  Ignore errors when formulas omit certain cells in a region.

• INCONSIST_FORMULA

  const int INCONSIST_FORMULA

  Ignore errors when a formula in a region of your worksheet differs from other formulas in the same region.

• TWO_DIGIT_TEXT_YEAR

  const int TWO_DIGIT_TEXT_YEAR

  Ignore errors when formulas contain text formatted cells with years represented as 2 digits.

• TEXT_DATE

  const int TEXT_DATE

  Ignore errors when formulas contain text formatted cells with years represented as 2 digits.

  NOTE: This member is now obsolete. Instead, please use ErrorCheckType.TwoDigitTextYear enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.

• UNLOCKED_FORMULA

  const int UNLOCKED_FORMULA

  Ignore errors when unlocked cells contain formulas.

• UNPROCTED_FORMULA

  const int UNPROCTED_FORMULA

  Ignore errors when unlocked cells contain formulas.

  NOTE: This member is now obsolete. Instead, please use ErrorCheckType.UnproctedFormula enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.

• TABLE_DATA_VALIDATION

  const int TABLE_DATA_VALIDATION

  Ignore errors when a cell's value in a Table does not comply with the Data Validation rules specified.

• VALIDATION

  const int VALIDATION

  Ignore errors when a cell's value in a Table does not comply with the Data Validation rules specified.

  NOTE: This member is now obsolete. Instead, please use ErrorCheckType.TableDataValidation enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.

• CALCULATED_COLUMN

  const int CALCULATED_COLUMN

  Ignore errors when cells contain a value different from a calculated column formula.