Edit a cell

Suite and Optimus Suite 5
#1

When i am trying to edit a cell with values 0, the cell is not filled with 0.Instead it is filled with blank .Here is the peice of code in my jsp



mygrid3.cells(gridrow,1).setValue(name);

// alert(“capacityArray”+capacityArray);

var k = 2;

for(var j = 0 ; j < capacityArray.length ; j++) {

mygrid3.cells(gridrow,k).setValue(capacityArray[j]);

k = k+1;

}



where capacity Array holds the value as 0. Please let me know do i need to set any attribute in the XML.Looking forward for the reply.

#2

The code snippet is correct.
Default column types, such as “ed”|“ro” or siimilar will set value as is, some others may do such conversion ( 0 to empty space )
Which column type used in your case ?

#3


I defined the column types as



mygrid3.setColTypes(“tree,ed,ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=c2+c3+c4+c5+c6+c7+c8+c9+c10+c11+c12+c13]”);



please let me know is this correct or not.

#4

There is a known issue with math based excells ( such as ed[=sum] ) which will treat incoming data as formulas ( which converts 0 to the empty value )
Please contact us directly at support@dhtmlx.com and provide your ref. number - we will patched code.