Dear All,

We have just released jQuery Calx update tagged as 2.1.0. This release introduce new single method named setValue into jQuery Calx.

You can use it to set the cell value without rendering it and calculate the sheet manually, the old way of setting the cell value is look like this

$('#sheet').getCell('A1').setValue('100').renderComputedValue();
$('#sheet').calx('calculate')

using the new method, it can be rewritten as

$('#sheet').calx('setValue', 'A1', '100');

Those will render the value immediately, set the internal reference, and calculate the sheet if autoCalculate option is enabled.

As usual, any feedback from you is much appreciated 🙂

Thanks