Enum ErrorCheckType

ErrorCheckType enumeration

Represents all error check type.

public enum ErrorCheckType

Values

Name	Value	Description
EvaluationError	1	Ignore errors when cells contain formulas that result in an error.
Calc	1
EmptyCellRef	2	Ignore errors when formulas refer to empty cells.
NumberStoredAsText	4	Ignore errors when numbers are formatted as text or are preceded by an apostrophe
TextNumber	4	Ignore errors when numbers are formatted as text or are preceded by an apostrophe
InconsistRange	8	Ignore errors when formulas omit certain cells in a region.
InconsistFormula	16	Ignore errors when a formula in a region of your worksheet differs from other formulas in the same region.
TwoDigitTextYear	32	Ignore errors when formulas contain text formatted cells with years represented as 2 digits.
TextDate	32	Ignore errors when formulas contain text formatted cells with years represented as 2 digits.
UnlockedFormula	64	Ignore errors when unlocked cells contain formulas.
UnproctedFormula	64	Ignore errors when unlocked cells contain formulas.
TableDataValidation	128	Ignore errors when a cell’s value in a Table does not comply with the Data Validation rules specified.
Validation	128	Ignore errors when a cell’s value in a Table does not comply with the Data Validation rules specified.
CalculatedColumn	129	Ignore errors when cells contain a value different from a calculated column formula.

Examples

namespace AsposeCellsExamples
{
    using Aspose.Cells;
    using System;

    public class ErrorCheckTypeDemo
    {
        public static void ErrorCheckTypeExample()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();
            Worksheet worksheet = workbook.Worksheets[0];

            // Access the ErrorCheckOptionCollection
            ErrorCheckOptionCollection errorCheckOptions = worksheet.ErrorCheckOptions;

            // Add a new ErrorCheckOption
            int optionIndex = errorCheckOptions.Add();
            ErrorCheckOption errorCheckOption = errorCheckOptions[optionIndex];

            // Set various error check types to false
            errorCheckOption.SetErrorCheck(ErrorCheckType.InconsistFormula, false);
            errorCheckOption.SetErrorCheck(ErrorCheckType.InconsistRange, false);
            errorCheckOption.SetErrorCheck(ErrorCheckType.TextDate, false);
            errorCheckOption.SetErrorCheck(ErrorCheckType.TextNumber, false);
            errorCheckOption.SetErrorCheck(ErrorCheckType.Validation, false);

            // Define a cell area for the error check option
            CellArea cellArea = CellArea.CreateCellArea("A1", "B10");
            errorCheckOption.AddRange(cellArea);

            // Save the workbook
            workbook.Save("ErrorCheckTypeExample.xlsx");
            workbook.Save("ErrorCheckTypeExample.pdf");
        }
    }
}

See Also

• namespace Aspose.Cells
• assembly Aspose.Cells