Grid not refreshing after loading data

Suite and Optimus Suite 5
#1

Hi,



I’m having a problem to refresh a grid after loading data from javascript String.



Here is my grid declaration from HTML table :



    

        

        

        

        

        

        

        

        

        

    



            Mission begin date

        

            Begin hour

        

            Mission end date

        

            End hour (hh:mm)

        

            Country

        

            Group

        

            Amount / day

        

            Nb of day

        		 Total(�)

        






As you can see column “Total” is math formula of column 6 and 7 --> The total column is correctly updated when the string “values” contains no value --> I can add, delete lines the column is correctly updated.



My problem appears when i load “values” which contains some rows : For example :



<?xml version="1.0"?>





09/12/2008

08:00

13/12/2008

18:00

9

Groupe 2

23

4

92

…/images/grid/add.png^javascript:addRow()^_self|…/images/grid/delete.png^javascript:deleteRow()^_self







When i change values in column 6 or 7 the total column isn’t calculated. Why ?



I give you samples here : zepload.com/images/1228901162_BadCalculation.png
#2

When i change values in column 6 or 7 the total column isn’t calculated. Why ?
Formula used for column will be applied only if related cell is empty. In your case it already has some predefined value ( 92 ) , so grid not uses formula but constant value from XML
If you need to have this column auto-calculated, not specify its value in XML

or specify it as formula
=c6*c7

#3

Basically - value in XML override formula defined for column.

#4

Thanks for your quick answer I try it and i come back to you

#5

I have to store XML in database so can i delete total column value from XML using serialisation method ???

For example, i should see 92 in cell but no value in xml. Can i do that ?

<?xml version="1.0"?>





09/12/2008

08:00

13/12/2008

18:00

9

Groupe 2

23

4




…/images/grid/add.png^javascript:addRow()^_self|…/images/grid/delete.png^javascript:deleteRow()^_self





#6

Can be done by adding next line before grid’s init

eXcell_math.prototype.getMathValue=function(){
return “”;
}

and next line as part of grid’s init
mygrid.enableMathSerialization(true);
as result all math based cells will be serialized as empty ones

#7

Thanks for answers !!! My form works fine !!!