com.aspose.cells
Class ErrorCheckOption

java.lang.Object
    com.aspose.cells.ErrorCheckOption

public class ErrorCheckOption 
extends java.lang.Object

Workbook workbook = new Workbook();
ErrorCheckOptionCollection opts = workbook.getWorksheets().get(0).getErrorCheckOptions();
int optionIdx = opts.add();
ErrorCheckOption opt = opts.get(optionIdx);
opt.setErrorCheck(com.aspose.cells.ErrorCheckType.INCONSIST_FORMULA, false);
opt.setErrorCheck(com.aspose.cells.ErrorCheckType.INCONSIST_RANGE, false);
opt.setErrorCheck(com.aspose.cells.ErrorCheckType.TEXT_DATE, false);
opt.setErrorCheck(com.aspose.cells.ErrorCheckType.TEXT_NUMBER, false);
opt.setErrorCheck(com.aspose.cells.ErrorCheckType.VALIDATION, false);
opt.addRange(CellArea.createCellArea("A1", "B10"));
workbook.save("Book1.xlsx");

public boolean isErrorCheck(int errorCheckType)

Checks whether given error type will be checked.

Parameters:

errorCheckType - A ErrorCheckType value. error type can be checked

Returns:

return true if given error type will be checked(green triangle will be shown for cell if the check failed).

public void setErrorCheck(int errorCheckType, boolean isCheck)

Sets whether given error type will be checked.

Parameters:

errorCheckType - A ErrorCheckType value. error type can be checked.

isCheck - true if given error type needs to be checked(green triangle will be shown for cell if the check failed).

public int getCountOfRange()

Gets the count of ranges that influenced by this setting.

Returns:

the count of ranges that influenced by this setting.

public int addRange(CellArea ca)

Adds one influenced range by this setting.

Parameters:

ca - the range to be added.

Returns:

the index of the added range in the range list of this setting.

public CellArea getRange(int index)

Gets the influenced range of this setting by given index.

Parameters:

index - the index of range

Returns:

return influenced range at given index.

public void removeRange(int index)

Removes one range by given index.

Parameters:

index - the index of the range to be removed.