Class ErrorCheckOptionCollection

ErrorCheckOptionCollection class

Represents all error check option.

public class ErrorCheckOptionCollection : CollectionBase<ErrorCheckOption>

Properties

NameDescription
Capacity { get; set; }
Count { get; }
Item { get; }Gets ErrorCheckOption object by the given index.
Item { get; set; }

Methods

NameDescription
Add()Add an error check option.
BinarySearch(ErrorCheckOption)
BinarySearch(ErrorCheckOption, IComparer<ErrorCheckOption>)
BinarySearch(int, int, ErrorCheckOption, IComparer<ErrorCheckOption>)
Clear()
Contains(ErrorCheckOption)
CopyTo(ErrorCheckOption[])
CopyTo(ErrorCheckOption[], int)
CopyTo(int, ErrorCheckOption[], int, int)
Exists(Predicate<ErrorCheckOption>)
Find(Predicate<ErrorCheckOption>)
FindAll(Predicate<ErrorCheckOption>)
FindIndex(Predicate<ErrorCheckOption>)
FindIndex(int, Predicate<ErrorCheckOption>)
FindIndex(int, int, Predicate<ErrorCheckOption>)
FindLast(Predicate<ErrorCheckOption>)
FindLastIndex(Predicate<ErrorCheckOption>)
FindLastIndex(int, Predicate<ErrorCheckOption>)
FindLastIndex(int, int, Predicate<ErrorCheckOption>)
GetEnumerator()
IndexOf(ErrorCheckOption)
IndexOf(ErrorCheckOption, int)
IndexOf(ErrorCheckOption, int, int)
LastIndexOf(ErrorCheckOption)
LastIndexOf(ErrorCheckOption, int)
LastIndexOf(ErrorCheckOption, int, int)
RemoveAt(int)

Examples

using System;
using Aspose.Cells;

namespace AsposeCellsExamples
{
    public class CellsClassErrorCheckOptionCollectionDemo
    {
        public static void Run()
        {
            Workbook workbook = new Workbook();
            Worksheet worksheet = workbook.Worksheets[0];

            ErrorCheckOptionCollection errorCheckOptions = worksheet.ErrorCheckOptions;
            int optionIndex = errorCheckOptions.Add();
            ErrorCheckOption errorCheckOption = errorCheckOptions[optionIndex];

            errorCheckOption.SetErrorCheck(ErrorCheckType.InconsistFormula, false);
            errorCheckOption.SetErrorCheck(ErrorCheckType.TextNumber, false);

            CellArea cellArea = CellArea.CreateCellArea("A1", "C5");
            errorCheckOption.AddRange(cellArea);

            workbook.Save("ErrorCheckOptionsDemo.xlsx");
        }
    }
}

See Also