ErrorCheckOption

Inheritance: java.lang.Object

public class ErrorCheckOption

Error check setting applied on certain ranges.

Example

           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");

Methods

MethodDescription
addRange(CellArea ca)Adds one influenced range by this setting.
equals(Object arg0)
getClass()
getCountOfRange()Gets the count of ranges that influenced by this setting.
getRange(int index)Gets the influenced range of this setting by given index.
hashCode()
isErrorCheck(int errorCheckType)Checks whether given error type will be checked.
notify()
notifyAll()
removeRange(int index)Removes one range by given index.
setErrorCheck(int errorCheckType, boolean isCheck)Sets whether given error type will be checked.
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

addRange(CellArea ca)

public int addRange(CellArea ca)

Adds one influenced range by this setting.

Parameters:

ParameterTypeDescription
caCellAreathe range to be added.

Returns: int - the index of the added range in the range list of this setting.

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

getCountOfRange()

public int getCountOfRange()

Gets the count of ranges that influenced by this setting.

Returns: int - the count of ranges that influenced by this setting.

getRange(int index)

public CellArea getRange(int index)

Gets the influenced range of this setting by given index.

Parameters:

ParameterTypeDescription
indexintthe index of range

Returns: CellArea - return influenced range at given index.

hashCode()

public native int hashCode()

Returns: int

isErrorCheck(int errorCheckType)

public boolean isErrorCheck(int errorCheckType)

Checks whether given error type will be checked.

Parameters:

ParameterTypeDescription
errorCheckTypeintErrorCheckType. error type can be checked

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

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

removeRange(int index)

public void removeRange(int index)

Removes one range by given index.

Parameters:

ParameterTypeDescription
indexintthe index of the range to be removed.

setErrorCheck(int errorCheckType, boolean isCheck)

public void setErrorCheck(int errorCheckType, boolean isCheck)

Sets whether given error type will be checked.

Parameters:

ParameterTypeDescription
errorCheckTypeintErrorCheckType. error type can be checked.
isCheckbooleantrue if given error type needs to be checked(green triangle will be shown for cell if the check failed).

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