Dear sir,
I have two field call price and amount. while doing the price upadtion the amount field, Grant total field is not getting chages.
mygrid.setColTypes(“ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ed,ed[=c6c11]");
mygrid.setColumnColor(",#BCFAB4,");
mygrid.setMathRound(2);
mygrid.enableMathEditing(true);
ed[=c6c11] // amount field
Error 1: No updation in Amount filed after price field updation.
Error2 : in the grant total place(sum) i am getting like ‘#SCL’ message.
please give a solution.
my code:
tableData = tableData+”";
//tableData = tableData+"";
TotalAmount = TotalAmount +"[["+x+",13]]+"; // i am generating the String
System.out.println(“total amount” +TotalAmount);
Amount filed can not update if you are filling this field from xml with any value. If cell value is not empty and you are passing formular in this cell, cell value will not recalculate