Methods

addRange(ca) → Number

Adds one influenced range by this setting.

Parameter

Name Type Optional Description

ca

CellArea

 

the range to be added.

Returns

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

getCountOfRange() → Number

Gets the count of ranges that influenced by this setting.

Returns

Number the count of ranges that influenced by this setting.

getRange(index) → CellArea

Gets the influenced range of this setting by given index.

Parameter

Name Type Optional Description

index

Number

 

the index of range

Returns

CellArea return influenced range at given index.

isErrorCheck(errorCheckType) → boolean

Checks whether given error type will be checked.

Parameter

Name Type Optional Description

errorCheckType

Number

 

ErrorCheckType

Returns

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

removeRange(index)

Removes one range by given index.

Parameter

Name Type Optional Description

index

Number

 

the index of the range to be removed.

setErrorCheck(errorCheckType, isCheck)

Sets whether given error type will be checked.

Parameters

Name Type Optional Description

errorCheckType

Number

 

ErrorCheckType

isCheck

boolean

 

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