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
Worker task.
Parameter | Type | Description |
---|---|---|
context | Object |
Specify the context. |
taskFn | Function | { [key: string]: Function | string[] } |
Specify the task. |
callbackFn | Function |
Specify the callbackFn. |
data (optional) | Object[] |
Specify the data. |
preventCallback (optional) | boolean |
Specify the preventCallback. |
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