Start Building Professional
Web Apps Today

Math Column plus Footer not recalculating

I have 5 columns that I want to sum to a total column at the end. I am using "ron[=c3+c4+c5+c6+c7]" for the total, and that works great. I then attach a footer under the 5 columns and the total: "{#stat_total},{#stat_total},{#stat_total},{#stat_total},{#stat_total},{#stat_total}". The footers work great for the 5 regular columns.

However the last column footer does not recalculate. The 5 standard columns recalculate and the last column recalculates each row but that total column in the footer will not recalculate. When the grid initially loads the calculation is correct, but upon changing nothing happens.

Please check this article http://dhtmlx.com/docs/products/kb/index.shtml?cat=recent&q=8219

Also you can attach "onEditCell" event and call "onGridReconstructed" event to recalculate all footers:

mygrid.attachEvent("onEditCell",function(stage,rowId,cellInd,newValue,oldValue){
        if ((stage==2)&&(newValue!=oldValue)){
            mygrid.callEvent("onGridReconstructed",[]);
                                return true;
        }
return true;
    });