treegrid : change cell content

Discontinued products Uncategorized discussions
#1

Hi,



I have a question about changing cells content in a treegrid.



I have a column in a treegrid which is a math calculation like this : ed[=(c9+c10+c11)/c1*1000]]



The problem is that sometime C1 = 0 so i have Infini.ty or N.aN in the cells.



I would like to have a “-” instead.



So I tried to do this :



mygrid.attachEvent(“onXLE”,function(id) {

mygrid.forEachRow(function(id){

if ((mygrid.cells(id,12).cell.innerHTML==‘Infini.ty’) || (mygrid.cells(id,12).cell.innerHTML==‘N.aN’))

    mygrid.cells(id,12).cell.innerHTML=’-’;

if ((mygrid.cells(id,13).cell.innerHTML==‘Infini.ty’) || (mygrid.cells(id,12).cell.innerHTML==‘N.aN’))

    mygrid.cells(id,13).cell.innerHTML=’-’;

    });

});





The problem is that when a row is inside a parent row, onXLE event is executed before the calculation.



How could I do ? the best way (maybe) would be to find an event after all calculation in the treegrid



Any idea?



Best regards,

Olivier

#2


You can use “onCellChanged” event:


mygrid.attachEvent(“onCellChanged”,function(rowId,cellIndex,newValue){
if ((newValue==“N.aN”)||(newValue==“Infini.ty”))
mygrid.cellById(rowId,cellIndex).setValue("-");
});



#3

Thank you very much  ! It works great :slight_smile: