We are happy to announce new release of jQuery Calx, tagged under version 2.2.0. This release introduce new single feature to enable you to pass formula, value, and format upon calx initialization instead write up data-formula and data-format directly into html which make the html size bigger and non-cacheable on dynamically generated page, but the data-cell attribute is still required.

You can pass the cell formula, format, and value into data key of the calx configuration object

<form id="calx">
    <table>
        <tr>
            <td><input data-cell="A1"></td>
            <td><input data-cell="A2"></td>
            <td><input data-cell="A3"></td>
            <td><input data-cell="A4"></td>
            <td><input data-cell="A5"></td>
            <td><input data-cell="A6"></td>
            <td><input data-cell="A7"></td>
            <td><input data-cell="A8"></td>
            <td><input data-cell="A9"></td>
            <td><input data-cell="A10"></td>
        </tr>
    </table>
</form>

 

$('#calx').calx({
    data : {
        A1  : {
            value : 500,
            format : '$ 0,0'
        }
        A10 : {
            formula : 'SUM(A1:A9)',
            format  : '$ 0,0'
        }
    }
});

By passing the data into calx configuration, calx will set the formula, value and format of the cell when it initialized, and it will overwrite the data-formula and data-format value when present.

As usual, any feedback from you is much appreciated :)

Thanks