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. |