I am trying to move rows between grids. The rows have the exact same column structure. I am loading both grids via XML. I have 5 columns that are summed to a total column at the end. When working with current data the math calculations work just fine. However when I move a row from one grid to the other it appears to copy the value from the total column over and lock it. When I modify the row it doesn’t update the math calculation in the moved row. I am also using dataprocessor so I am not sure if that is affecting it.
Add following code to the grid initialization:
mygrid.attachEvent(“onRowAdded”,function(id){
this.cells(id,4).setValue("=c2*c3");
})