Member | Description |
---|---|
EmptyCellReferences | Ignore the error when formula contains a reference to an empty cell. |
EvaluateToError | Ignore the error of the formula result error. Formula result error types include CalcError.Div0, CalcError.NA, CalcError.Name, CalcError.Null, CalcError.Num, CalcError.Ref, and CalcError.Value. |
InconsistentFormula | Ignore the error of discrepancies in formulas within a range. |
InconsistentListFormula | Ignore the error of discrepancies in formulas within a calculated column. |
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. |
NumberAsText | Ignore the error in cells containing numbers stored as text or preceded by an apostrophe. |
OmittedCells | Ignore the error in cells containing formulas referring to a range that omits adjacent cells that could be included. |
TextDate | Ignore the error when formulas contain text formatted cells with years misinterpreted as the wrong century. |
UnlockedFormulaCells | Ignore the error in unlocked cells containing formulas. |