javascript - jquery.sheet trigger formula calculation on cell -
That's why I am loading a CSV file from a server which includes an inserted JS function call, which with jquery.sheet tables / sheets Make them. Everything works by now, but when I put the function in the list, they do not count.
Sheet (simplified) data object for TD is before I am modifying anything:
object {td: x.fn.x.init [1 ] Dependency: array [0], formula: "", celltype: empty, value: "= A2 + B2 + C2" ...}
When I set the formula value So it changes:
object {td: x.fn.x.init [1], Dependency: Array [0], formula: "= A2 + B2 + C2" , Celltype: empty, value: "= A2 + B2 + C2" ...}
So I understand how to determine the formula and value What I want to do on A is to expect an event to trigger self to calculate the cell based on the coordination of an "X, Y" triggers an event, or it determines whether I have a wrong approach I am not sure what it helps, but when I edit a cell, then it is == A2 + B2 + C2 no = A2 + B2 + C2
Aswill appear, I will supply my code, but C # ASP Because of the reason and JS Interaction it is not low I do not think it will help.
Resolve:
Formula for a jquery.sheet instance from a CSV file Two things are needed to load and then it does calculate firstly the objects ["formula"] are to manually set the property, whereas in the beginning except '=', because it adds itself So you have to trigger with the "calc (s, true)" function as a sheet index, and in my case i am going to have another parameter I think really clearly because I sure It is calculated on the cells with a function.
var sheets = jQuery.sheet.instance [0]; For (var s = 0; s If a better method has been found please tell me, I do not think that it is very scalable because it is O (N ^ 3).
Comments
Post a Comment