Cell object is created after sheet object is completely initialized, and is stored in the cells registry inside the sheet object. You can retreive this cell object using two methods, via calx api, and via sheet object

$(selector).calx('getCell', cellAddress)

or

sheet.getCell(cellAddress)

After cell object is retrieved, you can access all the method available in cell object

calculate

cell.calculate()

Evaluate the formula of the current cell, and all it’s dependant (all cells that depends on this cell)

evaluateFormula

cell.evaluateFormula()

Calculate only formula of this cell, and return the value.

getAddress

cell.getAddress()

Get the cell address of current cell object.

getFormat

cell.getFormat()

Get the formatting rule.

getFormattedValue

cell.getFormattedValue()

Get the formatted value

getFormula

cell.getFormula()

Get the formula

getValue

cell.getValue()

Get the raw value of the cell, if cell has formula defined, it will return the calculated value

renderComputedValue

cell.renderComputedValue()

Render the computed value to the cell’s element

setConditionalStyle

cell.setConditionalStyle(function(value, element){})

Setup conditional styling for the cell element, it should be function with the cell value as first parameter, and jQuery object of the cell element as second parameter

setFormat

cell.setFormat(format)

Set the formatting rule of the current cell.

Please note that you must not set the format on the fly via $(selector).attr('data-format', format) since jQuery Calx will not notice the change.

setFormula

cell.setFormula(formula)

Set the calculation formula of the current cell.

Please note that you must not set the formula on the fly via $(selector).attr('data-formula', formula) since jQuery Calx will not notice the change.

setValue

cell.setValue(value)

Set the value of the current cell.

Please note that you must not set the value on the fly via $(selector).val(value) since jQuery Calx will not notice the change.
Cell with formula defined, will not affected by this change since it will always return the calculated value.
Cell with data-format caontains % like 0%, 0.00 %, will parse 10 as 10% (0.1), 10% as 10%.