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

Building Advanced Calculation form using jQuery Calx

Recently I have a lot of task from my several client that ask me to convert their excel spreadsheet into fully working web based apps. Everything is fine when I build the form using standard jQuery event to trigger the calculation, getting value from each field, pass the calculation result to the target field, etc. But things become very slow and make my browser not responsive when the form contain lot of field and the calculation script start their work, triggering blur event on every field that need to be calculated, etc, etc, till I  noticed that I was the [...]

By |2017-05-17T19:57:39+07:00December 17th, 2012|Categories: jquery-calx|Tags: , , , , |0 Comments
Go to Top