Class ExcelIgnoredError¶

Namespace: OfficeOpenXml
Assembly: EPPlus.dll

Error ignore options for a worksheet

public class ExcelIgnoredError : XmlHelper

Properties¶

The address

public ExcelAddressBase Address { get; }

Calculated Column

public bool CalculatedColumn { get; set; }

Ignore errors when a formula refers an empty cell

public bool EmptyCellReference { get; set; }

Ignore errors when formulas fail to Evaluate

public bool EvaluationError { get; set; }

Ignore errors when a formula in a region of your worksheet differs from other formulas in the same region.

public bool Formula { get; set; }

Ignore errors when formulas omit certain cells in a region.

public bool FormulaRange { get; set; }

Ignore errors when a cell's value in a Table does not comply with the Data Validation rules specified

public bool ListDataValidation { get; set; }

Ignore errors when numbers are formatted as text or are preceded by an apostrophe

public bool NumberStoredAsText { get; set; }

Ignore errors when formulas contain text formatted cells with years represented as 2 digits.

public bool TwoDigitTextYear { get; set; }

Ignore errors when unlocked cells contain formulas

public bool UnlockedFormula { get; set; }