Feb 20, 2016
fix variable scope leak

@ikhsan017 ikhsan017 released this Feb 19, 2016 · 18 commits to master since this release

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

@ikhsan017 ikhsan017 released this Dec 20, 2015 · 27 commits to master since this 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

Assets 2

@ikhsan017 ikhsan017 released this Dec 15, 2015 · 31 commits to master since this release

Fix calx refresh behaviour

Assets 2
Jun 12, 2015
update reference to 2.2.3, remove old build 2.2.2

@ikhsan017 ikhsan017 released this May 28, 2015 · 42 commits to master since this release

Fix bug on SUMPRODUCT formula which always return 0

Assets 2

@ikhsan017 ikhsan017 released this Apr 25, 2015 · 48 commits to master since this release

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

Assets 2

@ikhsan017 ikhsan017 released this Apr 14, 2015 · 49 commits to master since this release

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>
Assets 2

@ikhsan017 ikhsan017 released this Mar 23, 2015 · 56 commits to master since this release

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

Assets 2

@ikhsan017 ikhsan017 released this Mar 20, 2015 · 59 commits to master since this release

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.

Assets 2