Fixed number of grid to 31 rows and add the second columns
Posted: Thu Jul 29, 2021 1:53 pm
i want Fix the grid to 31 rows and add the second columns
with this code but it not work and i do not know why??? plz help
for (i=0; i < 30; i++) {
$("#gridVar001").addRow();
$("#gridVar002").addRow();
}
$("#60812377960ff8494201cb7011756346").mouseover(function(){
var row1= $("#gridVar001").getNumberRows();
var col_grid1 = 0;
var total_grid1 = 0;
var row2= $("#gridVar002").getNumberRows();
var col_grid2 = 0;
var total_grid2 = 0;
var total = 0;
for(var i=1;i<=row1;i++){
col_grid1 = parseInt($("#gridVar001").getValue(i,5));
total_grid1 += col_grid1;
}
for(var j=1;j<=row2;j++){
col_grid2 = parseInt($("#gridVar002").getValue(j,5));
total_grid2 += col_grid2;
}
total = total_grid1 + total_grid2;
$("#sum").setValue(total);
});
with this code but it not work and i do not know why??? plz help
for (i=0; i < 30; i++) {
$("#gridVar001").addRow();
$("#gridVar002").addRow();
}
$("#60812377960ff8494201cb7011756346").mouseover(function(){
var row1= $("#gridVar001").getNumberRows();
var col_grid1 = 0;
var total_grid1 = 0;
var row2= $("#gridVar002").getNumberRows();
var col_grid2 = 0;
var total_grid2 = 0;
var total = 0;
for(var i=1;i<=row1;i++){
col_grid1 = parseInt($("#gridVar001").getValue(i,5));
total_grid1 += col_grid1;
}
for(var j=1;j<=row2;j++){
col_grid2 = parseInt($("#gridVar002").getValue(j,5));
total_grid2 += col_grid2;
}
total = total_grid1 + total_grid2;
$("#sum").setValue(total);
});