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
Namespace: 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 | 4 | Ignore errors of formulas which result in an error like #N/A! |
Formula | 8 | Ignore erors when a fomrula isn't similar to the other formulas in the region. |
FormulaRange | 16 | Ignore errors when a formula doesn't reference all cells in a range. |
ListDataValidation | 32 | Ignore errors when the cell value doesn't comply with the data validation rules. |
NumberStoredAsText | 64 | Ignore errors of numbers stored as text. |
TwoDigitTextYear | 128 | Ignore errors when formulas contain text formatted cells with years represented as 2 digits. |
UnlockedFormula | 256 | Ignore errors when unlocked cells contain formulas. |