|0||Do not ignore any error.|
|1||Ignore errors when cells contain formulas that result in an error such as '#VALUE!' or '#DIV/0!'.|
Ignore errors when cells contain a value different from a calculated column formula for tables.
In other words, for a calculated column, a cell in that column is considered to have an error if its formula is different from the calculated column formula, or doesn't contain a formula at all.
|4||Ignore errors when cells contain dates in text form with years represented as 2 digits.|
|8||Ignore errors when numbers are formatted as text or are preceded by an apostrophe.|
Ignore errors when a formula in a region of your worksheet differs from other formulas in the same region.
For example, if the formula in cell A1 is "=B1", and the formula in cell A3 is "=B3", but the formula in cell A2 is not "=B2" but instead "=C2", then A1 and A3 both refer to the cell one column to their right, but A2 does not and so is inconsistent with them.
Ignore errors when formulas omit certain cells in a region.
For example, if there is data in cells A1:A100 and formula contains the reference "=SUM(A1:A98)".
|64||Ignore errors when unlocked (editable) cells in the locked sheet contain formulas.|
|128||Ignore errors when formulas refer to empty cells.|
Ignore errors when a cell's value in a Table does not comply with the Data Validation rules specified.
For example, when a cell's value is inconsistent with the column data type for Tables connected to SharePoint data.
|255||Ignore all errors.|
A cell is considered to have an error condition when it meets one of the conditions specified in the ErrorTypes member. For example, if a cell is formatted as text but contains a numeric value, this is considered to be a potential error because the number won't be treated as a number, for example, in calculations.
Note that this is simply a guess by the implementing application, and a recommendation to the user. Cells with the errors specified inmay have perfectly valid reasons for being in such a state, for example a cell formatted as text which contains numeric Postal Codes or Order numbers. It is useful to format these cells as text so that leading zeros remain as part of the value instead of being removed.
Following example shows that cells A1 and B1 both contain numbers stored as text, and this error has been reviewed and specifically flagged to be no longer surfaced as an error to the user.
var workbook = new ExcelFile(); var worksheet = workbook.Worksheets.Add("Sheet1"); worksheet.Cells["A1"].Value = "00385"; worksheet.Cells["B1"].Value = "00387"; worksheet.IgnoredErrors.Add("A1 B1", IgnoredErrorTypes.NumberStoredAsText);
Dim workbook = New ExcelFile() Dim worksheet = workbook.Worksheets.Add("Sheet1") worksheet.Cells("A1").Value = "00385" worksheet.Cells("B1").Value = "00387" worksheet.IgnoredErrors.Add("A1 B1", IgnoredErrorTypes.NumberStoredAsText)