Class ExcelIgnoredError

Error ignore options for a worksheet

Inheritance

System.Object

XmlHelper

ExcelIgnoredError

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.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
System.Boolean

EmptyCellReference

Ignore errors when a formula refers an empty cell

Declaration

public bool EmptyCellReference { get; set; }

Property Value

Type	Description
System.Boolean

EvaluationError

Ignore errors when formulas fail to Evaluate

Declaration

public bool EvaluationError { get; set; }

Property Value

Type	Description
System.Boolean

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
System.Boolean

FormulaRange

Ignore errors when formulas omit certain cells in a region.

Declaration

public bool FormulaRange { get; set; }

Property Value

Type	Description
System.Boolean

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
System.Boolean

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
System.Boolean

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
System.Boolean

UnlockedFormula

Ignore errors when unlocked cells contain formulas

Declaration

public bool UnlockedFormula { get; set; }

Property Value

Type	Description
System.Boolean