TIgnoredErrors Enumeration
Specifies what kind of errors Excel will ignore for ranges of cells. "Errors" in a spreadsheet are the green triangles that appear in the top left corner of the cell, like "Number stored as text".
Syntax
Unit: FlexCel.Core
Members
Name | Value | Description |
---|---|---|
None | 0 | Don't ignore any error. |
CalculatedColumn | 1 | Ignore errors when cells contain a formula different from the calculated column. |
EmptyCellReference | 2 | Ignore errors of formulas pointing to empty cell references. |
EvalError | 3 | Ignore errors of formulas which result in an error like #N/A! |
Formula | 4 | Ignore erors when a fomrula isn't similar to the other formulas in the region. |
FormulaRange | 5 | Ignore errors when a formula doesn't reference all cells in a range. |
ListDataValidation | 6 | Ignore errors when the cell value doesn't comply with the data validation rules. |
NumberStoredAsText | 7 | Ignore errors of numbers stored as text. |
TwoDigitTextYear | 8 | Ignore errors when formulas contain text formatted cells with years represented as 2 digits. |
UnlockedFormula | 9 | Ignore errors when unlocked cells contain formulas. |