ErrorCheckOption Class

Error check setting applied on certain ranges.
Inheritance Hierarchy
SystemObject
  Aspose.CellsErrorCheckOption

Namespace:  Aspose.Cells
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: 20.6.0.0 (20.6)
Syntax
public class ErrorCheckOption

The ErrorCheckOption type exposes the following members.

Methods
  NameDescription
Public methodAddRange
Adds one influenced range by this setting.
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetCountOfRange
Gets the count of ranges that influenced by this setting.
Public methodGetHashCode (Inherited from Object.)
Public methodGetRange
Gets the influenced range of this setting by given index.
Public methodGetType (Inherited from Object.)
Public methodIsErrorCheck
Checks whether given error type will be checked.
Protected methodMemberwiseClone (Inherited from Object.)
Public methodRemoveRange
Removes one range by given index.
Public methodSetErrorCheck
Sets whether given error type will be checked.
Public methodToString (Inherited from Object.)
Examples
[C#]

  Workbook workbook = new Workbook();
  ErrorCheckOptionCollection opts = workbook.Worksheets[0].ErrorCheckOptions;
  int optionIdx = opts.Add();
  ErrorCheckOption opt = opts[optionIdx];
  opt.SetErrorCheck(Aspose.Cells.ErrorCheckType.InconsistFormula, false);
  opt.SetErrorCheck(Aspose.Cells.ErrorCheckType.InconsistRange, false);
  opt.SetErrorCheck(Aspose.Cells.ErrorCheckType.TextDate, false);
  opt.SetErrorCheck(Aspose.Cells.ErrorCheckType.TextNumber, false);
  opt.SetErrorCheck(Aspose.Cells.ErrorCheckType.Validation, false);
  opt.AddRange(CellArea.CreateCellArea("A1", "B10"));
  workbook.Save(@"D:\Filetemp\Book1.xlsx");

[Visual Basic]

   Dim workbook As Workbook = New Workbook()
   Dim opts As ErrorCheckOptionCollection = workbook.Worksheets(0).ErrorCheckOptions
   Dim optionIdx As Integer = opts.Add()
   Dim opt As ErrorCheckOption = opts(optionIdx)
   opt.SetErrorCheck(Aspose.Cells.ErrorCheckType.InconsistFormula, False)
   opt.SetErrorCheck(Aspose.Cells.ErrorCheckType.InconsistRange, False)
   opt.SetErrorCheck(Aspose.Cells.ErrorCheckType.TextDate, False)
   opt.SetErrorCheck(Aspose.Cells.ErrorCheckType.TextNumber, False)
   opt.SetErrorCheck(Aspose.Cells.ErrorCheckType.Validation, False)
   opt.AddRange(CellArea.CreateCellArea("A1", "B10"))
   workbook.Save("D:\Filetemp\Book1.xlsx")
See Also