Root static functions of Spreadsheet Component
To get cell address from given row and column index.
Parameter | Type | Description |
---|---|---|
sRow | number |
Specifies the row. |
sCol | number |
Specifies the col. |
Returns string
To get single cell indexes
Parameter | Type | Description |
---|---|---|
address | string |
Specifies the address. |
Returns number[]
To get column header cell text
Parameter | Type | Description |
---|---|---|
colIndex | number |
Specifies the colIndex. |
Returns string
To get range address from given range indexes.
Parameter | Type | Description |
---|---|---|
range | number[] |
Specifies the range. |
Returns string
To get range indexes.
Parameter | Type | Description |
---|---|---|
range | string |
Specifies the range. |
Returns number[]
Check whether the text is formula or not.
Parameter | Type | Description |
---|---|---|
text | string |
Specify the text. |
isEditing (optional) | boolean |
Specify the isEditing. |
Returns boolean
Check whether the value is cell reference or not.
Parameter | Type | Description |
---|---|---|
value | string |
Specify the value to check. |
Returns boolean
Check whether the value is character or not.
Parameter | Type | Description |
---|---|---|
value | string |
Specify the value to check. |
Returns boolean
If the primary cell in the merged range row/column is hidden, then this method will update the next visible row/column index within the merged range.
Parameter | Type | Description |
---|---|---|
args | VisibleMergeIndexArgs |
Specifies the args. |
Returns void
Worker task.
Parameter | Type | Description |
---|---|---|
context | Object |
Specify the context. |
taskFn | Function | { : } | Specify the task. |
|
callbackFn | Function |
Specify the callbackFn. |
data (optional) | Object[] |
Specify the data. |
preventCallback (optional) | boolean |
Specify the preventCallback. |
parent (optional) | Workbook |
Specify the Workbook instance. |
Returns WorkerHelper
To Get the number built-in format code from the number format type.
Parameter | Type | Description |
---|---|---|
type | NumberFormatType |
Specifies the type of the number formatting. |
Returns string