Class ExcelIgnoredError
Error ignore options for a worksheet
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 : XmlHelperProperties
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 |
|---|---|
| Boolean |
EmptyCellReference
Ignore errors when a formula refers an empty cell
Declaration
public bool EmptyCellReference { get; set; }Property Value
| Type | Description |
|---|---|
| Boolean |
EvaluationError
Ignore errors when formulas fail to Evaluate
Declaration
public bool EvaluationError { get; set; }Property Value
| Type | Description |
|---|---|
| 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 |
|---|---|
| Boolean |
FormulaRange
Ignore errors when formulas omit certain cells in a region.
Declaration
public bool FormulaRange { get; set; }Property Value
| Type | Description |
|---|---|
| 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 |
|---|---|
| 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 |
|---|---|
| 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 |
|---|---|
| Boolean |
UnlockedFormula
Ignore errors when unlocked cells contain formulas
Declaration
public bool UnlockedFormula { get; set; }Property Value
| Type | Description |
|---|---|
| Boolean |