Show / Hide Table of Contents

Class ExcelIgnoredError

Error ignore options for a worksheet

Inheritance
System.Object
XmlHelper
ExcelIgnoredError
Inherited Members
XmlHelper.AddSchemaNodeOrder(String[], String[])
XmlHelper.AddSchemaNodeOrder(String[], String[], Int32[])
XmlHelper.GetBoolFromString(String)
XmlHelper.CreatespPrNode(String, Boolean)
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

CalculatedColumm

Calculated Column

Declaration
public bool CalculatedColumm { 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
Back to top Generated by DocFX