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

Method	Description
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:

Parameter	Type	Description
ca	CellArea	the 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:

Parameter	Type	Description
arg0	java.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:

Parameter	Type	Description
index	int	the 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:

Parameter	Type	Description
errorCheckType	int	ErrorCheckType. 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:

Parameter	Type	Description
index	int	the 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:

Parameter	Type	Description
errorCheckType	int	ErrorCheckType. error type can be checked.
isCheck	boolean	true 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:

Parameter	Type	Description
arg0	long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

Parameter	Type	Description
arg0	long
arg1	int