Table of Contents

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.