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