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

As

will 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

Popular posts from this blog

apache - 504 Gateway Time-out The server didn't respond in time. How to fix it? -

c# - .net WebSocket: CloseOutputAsync vs CloseAsync -

c++ - How to properly scale qgroupbox title with stylesheet for high resolution display? -