ErrorCheckOption
Contents
[
Hide
]ErrorCheckOption class
Error check setting applied on certain ranges.
Methods
| Name | Description |
|---|---|
| isErrorCheck | Checks whether given error type will be checked. |
| setErrorCheck | Sets whether given error type will be checked. |
| getCountOfRange | Gets the count of ranges that influenced by this setting. |
| addRange | Adds one influenced range by this setting. |
| getRange | Gets the influenced range of this setting by given index. |
| removeRange | Removes one range by given index. |
isErrorCheck(errorCheckType)
Checks whether given error type will be checked.
| Parameter | Type | Description |
|---|---|---|
| errorCheckType | int | 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).
setErrorCheck(errorCheckType, isCheck)
Sets whether given error type will be checked.
| Parameter | Type | Description |
|---|---|---|
| errorCheckType | int | A ErrorCheckType value. 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). |
getCountOfRange()
Gets the count of ranges that influenced by this setting.
Returns: the count of ranges that influenced by this setting.
addRange(ca)
Adds one influenced range by this setting.
| Parameter | Type | Description |
|---|---|---|
| ca | CellArea | the range to be added. |
Returns: the index of the added range in the range list of this setting.
getRange(index)
Gets the influenced range of this setting by given index.
| Parameter | Type | Description |
|---|---|---|
| index | int | the index of range |
Returns: return influenced range at given index.
removeRange(index)
Removes one range by given index.
| Parameter | Type | Description |
|---|---|---|
| index | int | the index of the range to be removed. |