Hotfix Release

• Fix SUMIF and SUMIFS behaviour
• Remove domain protection on sample js file, so it can be uploaded everywhere

Hotfix Release

This release come with several improvement:

• Fix vlookup behaviour to comply with excel's vlookup
• Add new feature to register cell data without creating html element of that cell

<form id="calx">
    <input data-cell="B1">
</form>

initialize calx with hidden cell

$('#calx').calx({
    data : {
         'A1' : { value: 100 },
         'A2' : { value: 200 },
         'A3' : { value: 150 },
         'A4' : { value: 50 },
         'B1' : { formula: 'SUM(A1:A4)' },
    }
});

and B1's value will 500

Fix calx refresh

Fix calx refresh behaviour

Fix SUMPRODUCT formula

Fix bug on SUMPRODUCT formula which always return 0

Fix registerVariable

This release fix registerVariable behaviour, when registered without selector, it will be registered as global, and when registered into specific sheet, it will recalculate the sheet

Add new data config key

This release introduce new data config key, enable you to strip the data-formula and data-format attribute out of your html.

For example

<form id="calx">
    <input data-cell="A1">
    <input data-cell="A2">
    <input data-cell="A3">
</form>
<script>
    $('#calx').calx({
        data : {
            A1 : { value : 200 , format : '$ 0,0' },
            A1 : { value : '50%' , format : '0 %' },
            A3 : { formula : 'A1-(A1*A2)' }
        }
    });
</script>

Fix cell initialization

Fix the cell initialization behavior: for cell with data-format attribute and non-empty numeric value, it will render the formatted value on initialization

Add new setValue method

This release introduce new single calx method named setValue to set the cell value of the selected sheet. You can now set the cell value via calx method

$('#sheet').calx('setValue', 'B1', 100)

And it will act as how $('#sheet').find('[data-cell=B1]').val(100) works, but also update the internal reference, and calculate the sheet if autoCalculate is enabled.

Fix parser error

Previously A1>A2 raise a parser error, but A1 > A2 (with the surrounding whitespace around the >) works fine.

This release fix those parser error, and A1>A2 notation should not raise an error anymore

Hotfix release

Fix COUNTIF and COUNTIFS function