Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by Alex on Jul 29, 2008 20:44
open dhtmlx forum
Custom Formula by cell (math)

Hello friend!

Is possible create custom "Math" formulas by cell (like a MS-Excel)??
If "yes", i need to include a JavaScriptEvent for each cell? How does it works ??????


Thanks
Alex
Answer posted by Support on Jul 30, 2008 02:33
The grid, has built in math support
    http://dhtmlx.com/docs/products/dhtmlxGrid/samples/rows_columns_manipulations/pro_math.html?un=1217411482000
    http://dhtmlx.com/docs/products/dhtmlxGrid/doc/guide.html#grid_math

The formulas can include cell references and any kind of js operators ( basically the code will be evaluated, so it may contain any valid js code )

The same effect may be achieved by using "onCellChanged" event, it triggered each time when any cell changed in grid, so it possible to add any kind of logic, which will update target cells, when source one changed by user.