Search results

Static Functions API in JavaScript (ES5) Spreadsheet API control

Root static functions of Spreadsheet Component

getCellAddress

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

getCellIndexes

To get single cell indexes

Parameter Type Description
address string Specifies the address.

Returns number[]

getColumnHeaderText

To get column header cell text

Parameter Type Description
colIndex number Specifies the colIndex.

Returns string

getRangeAddress

To get range address from given range indexes.

Parameter Type Description
range number[] Specifies the range.

Returns string

getRangeIndexes

To get range indexes.

Parameter Type Description
range string Specifies the range.

Returns number[]

checkIsFormula

Check whether the text is formula or not.

Parameter Type Description
text string Specify the text.
isEditing (optional) boolean Specify the isEditing.

Returns boolean

isCellReference

Check whether the value is cell reference or not.

Parameter Type Description
value string Specify the value to check.

Returns boolean

isChar

Check whether the value is character or not.

Parameter Type Description
value string Specify the value to check.

Returns boolean

executeTaskAsync

Worker task.

Parameter Type Description
context Object Specify the context.
taskFn Function | Object Specify the task.
callbackFn Function Specify the callbackFn.
data (optional) Object[] Specify the data.
preventCallback (optional) boolean Specify the preventCallback.

Returns WorkerHelper

getFormatFromType

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