Class ExcelIgnoredError

Error ignore options for a worksheet

Inheritance

object

XmlHelper

ExcelIgnoredError

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: OfficeOpenXml

Assembly: EPPlus.dll

Syntax

public class ExcelIgnoredError : XmlHelper

Properties

Address

The address

Declaration

public ExcelAddressBase Address { get; }

Property Value

Type	Description
ExcelAddressBase

CalculatedColumn

Calculated Column

Declaration

public bool CalculatedColumn { get; set; }

Property Value

Type	Description
bool

EmptyCellReference

Ignore errors when a formula refers an empty cell

Declaration

public bool EmptyCellReference { get; set; }

Property Value

Type	Description
bool

EvaluationError

Ignore errors when formulas fail to Evaluate

Declaration

public bool EvaluationError { get; set; }

Property Value

Type	Description
bool

Formula

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

Declaration

public bool Formula { get; set; }

Property Value

Type	Description
bool

FormulaRange

Ignore errors when formulas omit certain cells in a region.

Declaration

public bool FormulaRange { get; set; }

Property Value

Type	Description
bool

ListDataValidation

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

Declaration

public bool ListDataValidation { get; set; }

Property Value

Type	Description
bool

NumberStoredAsText

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

Declaration

public bool NumberStoredAsText { get; set; }

Property Value

Type	Description
bool

TwoDigitTextYear

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

Declaration

public bool TwoDigitTextYear { get; set; }

Property Value

Type	Description
bool

UnlockedFormula

Ignore errors when unlocked cells contain formulas

Declaration

public bool UnlockedFormula { get; set; }

Property Value

Type	Description
bool