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 dhtmlx.com/docs/products/dhtmlxG … t_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].