Hi,
Is it possible to pass data and get formulas calculated values as well as formula without rendering the values in table instance.
For Ex.
data:[
[0,20,’=(A1+B1)/D1’,30],
[20,20,’=(A2+B2)/D2’,40],
[20,0,’=(A3+B3)/D3’,50]
]
i need calculated value of formula as well as formula string. Then will manipulate these values depending upon some other constraints then populate these values in table.
If this is possible, kindly provide some example to implement this.
so you would like to hold a formula inside a cell but display an empty cell?
Can you tell more about the idea? What you would like to have when a user opens editor (by double clicking cell).
Hi
I will be adding some other data after manipulating results I will get from formula calculations. Not displaying formula on double clicking the cell.
For example:
In above table
Col A and B has some values, Col C has some formula (say A+B).
I need calculated values of col C cells then will manipulate these results (say c05, c17) depending upon some other constraints and input the final results in table to display the final result.
Now on every change in cells of col A & B I need to calculate A+B then manipulate and so on…
So what you would need is something like this http://jsfiddle.net/n5Larvth/?
You can still use other numeric values than only cell coordinates
In short is there any way to get calculated values of formulas without rendering a handsontable in UI ?
You can set visibility: hidden for the container. As you can see here the DIV that holds the table is not visible but we are able to get the formula value http://jsfiddle.net/fs0r5qL7/