Start Building Professional
Web Apps Today

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.


<link rel="STYLESHEET" type="text/css" href="../../../../js/common/dhtmlxgrid.css">
<link rel="STYLESHEET" type="text/css" href="../../../../js/common/dhtmlxgrid_skins.css">
<script src="../../../../js/common/dhtmlxcommon.js"></script>
<script src="../../../../js/common/dhtmlxgrid.js"></script>
<script src="../../../../js/common/dhtmlxgridcell.js"></script>
<script src="../../../../js/common/ext/dhtmlxgrid_selection.js"></script>
<script src="../../../../js/common/ext/dhtmlxgrid_nxml.js"></script>
<script src="../../../../js/common/dhtmlxgrid_excell_link.js"></script>

<script src="../../../../js/dhtmlxGrid/codebase/dhtmlxgrid.js"></script>
<script src="../../../../js/grid/dataProcessor/dhtmlxdataprocessor.js"></script>    
<script src="../../../../js/dhtmlxGrid/codebase/dhtmlxgrid_math.js"></script>
mygrid.setColTypes("ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ed,ed[=c6*c11]");
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+"<cell><![CDATA["+rs1.getString(12)+"]]></cell></row>";
        //tableData = tableData+"<cell><![CDATA["+Float.parseFloat(rs1.getString(12))*Float.parseFloat(rs1.getString(7))+"]]></cell></row>";    

        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