jQuery Calx 2.2.5 Released!

jQuery Calx is now reached version 2.2.5 and bring several bug fix and improvement since 2.2.0, and here is list of changes that has been made on jQuery Calx Fix registerVariable Fix calx refresh Fix bug on SUMPRODUCT formula function Fix bug on VLOOKUP formula function Fix incompatibility with IE Add feature to register cell without creating html element to be bound with the cell object You can now strip-out hidden element on your html file that act as proxy cell, and create cell directly by passing cell info into data section in the calx configuration. <form id="calx"> <input data-cell="B1"> [...]

By |2015-12-20T09:29:40+07:00December 20th, 2015|Categories: jquery-calx|11 Comments

jQuery Calx 2.2.0 Released

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 [...]

By |2017-05-17T19:57:19+07:00April 15th, 2015|Categories: jquery-calx|8 Comments

Handling “Maximum Call Stack Size Exceeded” in jQuery Calx

When you are building your web based calculator using jQuery Calx, it is a bit hard to track which cell refer to which cell, and sometimes circular reference occurred where some cell refer to itself, causing infinite loop of calculation operation and exceed the maximum call stack that can be handled by the javascript engine. For example: A1 is a cell with some value B1 is a cell with formula = A1+D1 C1 is a cell with formula = B1+10 D1 is a cell with formula = C1*3 In this case, when B1 is calculated, it will calculate it's dependencies [...]

By |2015-03-25T07:46:05+07:00March 25th, 2015|Categories: jquery-calx|Tags: , , |0 Comments

jQuery Calx 2.1.0 released

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

By |2015-03-20T08:18:11+07:00March 20th, 2015|Categories: jquery-calx|Tags: , |1 Comment

WP-Calx Form Builder – Build calculation form in wordpress with ease

Dear All, We just want to inform you, that we are currently in progress of building a wordpress plugin for jQuery Calx. It is kind of form builder, but specially designed and crafted to work seamlessly with jQuery Calx. The frontend form builder is around 90% completed, and will start to work on the backend once it finished. Once it completed, you can install it on your wordpress site, and built calculation form on wordpress as easy as drag and drop the form component, and set the cell address, formula, formatting on the element properties box. To display it on [...]

By |2017-05-17T19:57:19+07:00March 2nd, 2015|Categories: jquery-calx|Tags: , , |4 Comments

jQuery Calx 2.0.3 – HotFix release

jQuery Calx just reached version 2.0.3, this release is a hotfix of some bugs known on the previous version, here is the list of the changes made on this release: Fix checkbox behaviour, when the checkbox is unchecked, calculation is not updated Fix input with % in data-format attribute, so it parse correctly after update and refresh Fix refresh and update method, so it works perfectly on dynamic form Instalable via bower bower install jquery-calx You can grab the latest release here https://github.com/xsanisty/jquery-calx/archive/2.0.3.zip Please file an issue on github issue tracker if you found any problems when using jQuery Calx: [...]

By |2014-12-14T18:28:40+07:00December 11th, 2014|Categories: jquery-calx|11 Comments

Announcing jQuery Calx 2.x Lite edition

While developing the standard version of jQuery Calx 2.x, we add more and more features to the core, and import some features from another library to be integrated to the core. The most feature-set imported is formula from formula.js, until we realize that the raw codebase was sized ~300kb and the minified one is ~100kb when all feature is included. We realize that most user will not use all formula function available in jQuery Calx in their codebase, as the alternative, we are announcing the development of jQuery Calx 2.x-lite which only has some basic feature and most used formula [...]

By |2014-11-06T10:16:18+07:00November 6th, 2014|Categories: jquery-calx|0 Comments

jQuery Calx 2.0 finally released

After months of developments, and a year after the latest release, finally jQuery Calx 2.0 is now released. The core is rewritten from the scratch, but I feel it is still far from perfect. At the first time, we are planning to release it as closed source, but after long discussion with the team, I finally decided to release it as open-source plugin as we feel jQuery Calx will grow faster and more stable with support from the community. If you are interested in contributing to jQuery Calx development, here is the Github repo: https://github.com/xsanisty/jquery-calx You can fork it, and [...]

By |2017-05-17T19:57:19+07:00November 5th, 2014|Categories: jquery-calx|0 Comments

jQuery Calx Updated to 1.1.9

jQuery Calx is now updated to version 1.1.9, this release fix several bugs exists in previous version, also added some new feature. Remove missing element from the matrix registry when performing re-scan of dynamic form Remove calx reference from the form when calx is detached and remove it's related matrix registry Add OR and AND operator to process two or more logic condition inside IF statement Add "round" to calx option to determine how many decimal place displayed when textbox is focused You can download the 1.1.9 update from github here : https://github.com/ikhsan017/calx/archive/1.1.9.zip or get the latest update here I [...]

By |2017-05-17T19:57:24+07:00October 29th, 2013|Categories: javascript-calculator, jquery-calx|1 Comment

jQuery Calx Updated to Version 1.1.4

jQuery Calx is now updated to version 1.1.4. This update revision fix several bugs found in both IE 7 and IE 8, as version 1.1.2 did not work at all when accessed using both IE 7 and IE 8. You can download the latest update here https://github.com/ikhsan017/calx/archive/1.1.4.zip or try Calx in action here http://www.xsanisty.com/calx/showcase/ Your feedback will be much appreciated ;)

By |2013-06-29T20:47:44+07:00June 28th, 2013|Categories: javascript-calculator, jquery-calx|1 Comment
Go to Top