Class ExcelIgnoredError

Namespace

OfficeOpenXml

Assembly

EPPlus.dll

Error ignore options for a worksheet

public class ExcelIgnoredError : XmlHelper

Inheritance

object

XmlHelper

ExcelIgnoredError

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Properties

Address

The address

public ExcelAddressBase Address { get; }

Property Value

ExcelAddressBase

CalculatedColumn

Calculated Column

public bool CalculatedColumn { get; set; }

Property Value

bool

EmptyCellReference

Ignore errors when a formula refers an empty cell

public bool EmptyCellReference { get; set; }

Property Value

bool

EvaluationError

Ignore errors when formulas fail to Evaluate

public bool EvaluationError { get; set; }

Property Value

bool

Formula

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

public bool Formula { get; set; }

Property Value

bool

FormulaRange

Ignore errors when formulas omit certain cells in a region.

public bool FormulaRange { get; set; }

Property Value

bool

ListDataValidation

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

public bool ListDataValidation { get; set; }

Property Value

bool

NumberStoredAsText

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

public bool NumberStoredAsText { get; set; }

Property Value

bool

TwoDigitTextYear

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

public bool TwoDigitTextYear { get; set; }

Property Value

bool

UnlockedFormula

Ignore errors when unlocked cells contain formulas

public bool UnlockedFormula { get; set; }

Property Value

bool