Amount filed is not modifying

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[=c6
c11] // 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