IgnoredError Interface

Specifies a worksheet range and a type of the formula error which will be ignored in that range.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v18.2.Core.dll

Declaration

C#

public interface IgnoredError

VB.NET

Public Interface IgnoredError

Related API Members

The following members return IgnoredError objects:

• IgnoredErrorCollection.Add(Range, IgnoredErrorType)

Remarks

The IgnoredError object specifies an error-checking option and a worksheet range in which this option is disabled. Objects of the IgnoredError type are contained within the IgnoredErrorCollection collection accessible using the Worksheet.IgnoredErrors property.

The following code snippet disables checking empty cell references in cell A1.

C#

worksheet.IgnoredErrors.Add(worksheet["A1"], IgnoredErrorType.EmptyCellReferences);

VB.NET

worksheet.IgnoredErrors.Add(worksheet("A1"), IgnoredErrorType.EmptyCellReferences)