Initializing

Hello community,

I have a question, In this case, I have several excel sheets, I am implementing JQuery calx to be able to combine several excel sheets, the next formula the insert in a HTML table, example:

But the result is an #ERROR!

Exist other form the combinate the sheets.

Regards and thank.

Hi Ikhsan,

thanks for your answer to my previous question, I have got two questions 😉

1. The app I am working on requires several sheets to be made available in tabs. That’s not a problem as I assume that one can call several times calcx on different element. Is there a way to write formulas using data from another calcx object ? something along the lines of what Excel does with it’s sheet1! prefix ?

2. My ‘sheets’ are forms containing a table and each td cell has an input field. I tried to use simple divs with a contenteditable flag. in my context this is much lighter to use; unfortunately if does not seem that calcx knows how to pick up the html content of a div: so my question are there any restrictions to the type of html element usable ? A span is not really the answer as they are difficult to align properly (nor are they meant to be)

Thans for your time

Didier

Hi Ikhsan, great work for calx =). I would like to ask if this support named variable for data-cell, for example

$(‘#calx_form’).calx();

thank you!

iksahn,

I’d appreciate any help you might provide in determining why I am having the following problem implementing calx 2.2.2 (also tried with 2.2.0 sample).in my code. The samples ran fine (after i updated the src to refer to 2.2.2 and not 2.2.0; you may want to update).

FireBug is showing calx throwing the following error at line 9682, col 11 in jquery-calx-2.2.2.js under jquery 1.9.1 and 1.11.2.

TypeError: currentCell is undefined
oldVal = currentCell.getValue(),

I am initializing Calx in (document).ready using $(‘.Item01’).calx(); as it does not otherwise fire.

Here is the table markup.

Thank you.

Hi Ikhsan,

Thank you for this plugin.
I have values stored in a database.
I am filling a form input fields with these values inside a while loop.
Can you please show me how to use it to calculate the form values coming from a database? I tried and tried but nothing worked.

My form looks like this:
On each row, Balance equals debit minus credit.
Debit and credit need to come from the DB.

Thank you,
Mohamed

How can we replace the value=”15.00″ with the total amount calculated using calx 2 formula.

This is for Paypal form so we can tell Paypal the total amount.

Hi !
I’d like to launch calculation through a button but I face 2 issues : a button reload the page… so I try with a link and it reset the form instead of calculate.
Here’s my code :

var calc = jQuery('#roi').calx();
var sheet = calc.calx('getSheet');

jQuery('#compute').click(function(e){
  e.preventDefault();
  sheet.calculate();
});

Thanks a lot for your help !

i uploaded the new one and not working what am i doing wrong? please help.

http://www.newpane.mycalidesigns.com/sample/basic.html

please help i be more than happy to make a donation

It seems that the scope of data-cell names (A1, A2, etc…) is limited to the containing sheet. I’m not sure this is true, but if so, then two sheets on the same webpage could both have cells named A1 and they will not interfere with each other.

Is this how it works?

I’m working on a dynamic page where the user can add additional sheets (containing one or more forms). Keeping track of cell namespace is a hassle. I’d rather just have unique sheet names and the internal cells have the same naming convention regardless of which sheet contains them.

Thus… a simple page might look like this (notice than there are 3 sheets, but the cells are the same in each sheet):

    $('#sheet1').calx();
    $('#sheet2').calx();
    $('#sheet3').calx();