Each time jQuery Calx is initialized, sheet object is created for each selected element andstored in the sheet registry inside the calx object, you can retreive this sheet object usinggetSheet method.

Please note, that selector should retrieve single dom element to get correct sheet object. After sheet object is retreived, you can call all the method available.

calculate

sheet.calculate()

Calculate the whole sheet and display the result in each cell.

checkCircularReference

sheet.checkCircularReference()

Checking if circular reference exist in the sheet.

evaluate

sheet.evaluate(formula)

Evaluating formula in the current sheet.

getCell

sheet.getCell(cellAddress)

Get the cell object on the specified address.

getCellValue

sheet.getCellValue(cellAddress)

get value of the cell on specified address

getCellRange

sheet.getCellRange(rangeStart, rangeStop)

Get the cells object in the range, the result will be object looks like below

getCellRangeValue

sheet.getCellRangeValue(rangeStart, rangeStop)

Get value of the cells in the range, the result will be object looks like below

getVariable

sheet.getVariable(varName)

Get the defined variable value.

refresh

sheet.refresh()

Rebuild cell registry from the scratch.

reset

sheet.reset()

Reset the form inside sheet element to its original state.

update

sheet.update()

Update cell registry against any change in the sheet element.