Start Building Professional
Web Apps Today

Grid Custom Excel

I am trying to create a custom excel that allows for input of multiple number values. I have it working just fine. My raw values are stored for example: 3|5|6 in which case there are 3 numbers valued 3, 5 and 6. The value in the cell should be the sum so for this instance: 14.

All this works great, however I am trying to use a footer and a sum cell to the right to show total calculations. It appears they use the getValue() function to return the number they are wanting to use. But the dataprocessor also uses the getValue(). I need the sumation calcs to use 1 function and the dataproc to use another or is there a variable within an excel that they can use?

So:

dataprocessor needs to read 3|5|6 but the sumation needs to read 14.

Unfortunately there is no way to define 2 differend getValue() methods for the custom eXcell type. But you can implement custom autocalculated couter in the header/foother. Please see more information here http://dhtmlx.com/docs/products/dhtmlxGrid/doc/articles/Custom_stat_counters.html#grid_art_custstat

If you are sending data by dp.sendData() call, you can have code as

mygrid.setColTypes("ro,ro,ro,special_getter_type");
dp.sendData();
mygrid.setColTypes("ro,ro,ro,common_getter_type");

so , you can have two custom excell types, which differs by getValue method only, and temporary change column type during serialization

Thank you that worked for the column totals. How do I get it working for the row totals. I currently have a column defined as ron[=c4+c5+c6+c7+c8].