ErrorCheckType

Inheritance: java.lang.Object

public final class ErrorCheckType

Represents all error check type.

Fields

FieldDescription
CALCRemarks
CALCULATED_COLUMNIgnore errors when cells contain a value different from a calculated column formula.
EMPTY_CELL_REFIgnore errors when formulas refer to empty cells.
EVALUATION_ERRORIgnore errors when cells contain formulas that result in an error.
INCONSIST_FORMULAIgnore errors when a formula in a region of your worksheet differs from other formulas in the same region.
INCONSIST_RANGEIgnore errors when formulas omit certain cells in a region.
NUMBER_STORED_AS_TEXTIgnore errors when numbers are formatted as text or are preceded by an apostrophe
TABLE_DATA_VALIDATIONIgnore errors when a cell’s value in a Table does not comply with the Data Validation rules specified.
TEXT_DATEIgnore errors when formulas contain text formatted cells with years represented as 2 digits.
TEXT_NUMBERIgnore errors when numbers are formatted as text or are preceded by an apostrophe
TWO_DIGIT_TEXT_YEARIgnore errors when formulas contain text formatted cells with years represented as 2 digits.
UNLOCKED_FORMULAIgnore errors when unlocked cells contain formulas.
UNPROCTED_FORMULAIgnore errors when unlocked cells contain formulas.
VALIDATIONIgnore errors when a cell’s value in a Table does not comply with the Data Validation rules specified.

Methods

MethodDescription
equals(Object arg0)
getClass()
hashCode()
notify()
notifyAll()
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

CALC

public static final int CALC

Remarks

NOTE: This member is now obsolete. Instead, please use ErrorCheckType.EvaluationError enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.

CALCULATED_COLUMN

public static final int CALCULATED_COLUMN

Ignore errors when cells contain a value different from a calculated column formula.

EMPTY_CELL_REF

public static final int EMPTY_CELL_REF

Ignore errors when formulas refer to empty cells.

EVALUATION_ERROR

public static final int EVALUATION_ERROR

Ignore errors when cells contain formulas that result in an error.

INCONSIST_FORMULA

public static final int INCONSIST_FORMULA

Ignore errors when a formula in a region of your worksheet differs from other formulas in the same region.

INCONSIST_RANGE

public static final int INCONSIST_RANGE

Ignore errors when formulas omit certain cells in a region.

NUMBER_STORED_AS_TEXT

public static final int NUMBER_STORED_AS_TEXT

Ignore errors when numbers are formatted as text or are preceded by an apostrophe

TABLE_DATA_VALIDATION

public static final int TABLE_DATA_VALIDATION

Ignore errors when a cell’s value in a Table does not comply with the Data Validation rules specified.

TEXT_DATE

public static final int TEXT_DATE

Ignore errors when formulas contain text formatted cells with years represented as 2 digits.

Remarks

NOTE: This member is now obsolete. Instead, please use ErrorCheckType.TwoDigitTextYear enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.

TEXT_NUMBER

public static final int TEXT_NUMBER

Ignore errors when numbers are formatted as text or are preceded by an apostrophe

Remarks

NOTE: This member is now obsolete. Instead, please use ErrorCheckType.NumberStoredAsText enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.

TWO_DIGIT_TEXT_YEAR

public static final int TWO_DIGIT_TEXT_YEAR

Ignore errors when formulas contain text formatted cells with years represented as 2 digits.

UNLOCKED_FORMULA

public static final int UNLOCKED_FORMULA

Ignore errors when unlocked cells contain formulas.

UNPROCTED_FORMULA

public static final int UNPROCTED_FORMULA

Ignore errors when unlocked cells contain formulas.

Remarks

NOTE: This member is now obsolete. Instead, please use ErrorCheckType.UnproctedFormula enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.

VALIDATION

public static final int VALIDATION

Ignore errors when a cell’s value in a Table does not comply with the Data Validation rules specified.

Remarks

NOTE: This member is now obsolete. Instead, please use ErrorCheckType.TableDataValidation enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.

equals(Object arg0)

public boolean equals(Object arg0)

Parameters:

ParameterTypeDescription
arg0java.lang.Object

Returns: boolean

getClass()

public final native Class<?> getClass()

Returns: java.lang.Class

hashCode()

public native int hashCode()

Returns: int

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

ParameterTypeDescription
arg0long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

ParameterTypeDescription
arg0long
arg1int