Set cell value using SetValue() method not working

[eiwai]

Hi,

I am trying to set cell value using SetValue() method from javascript. My requirement is after update some value on column 1, I need to update value on column 3. It did change the value after I use setvalue() method. But after I tap out from third column, the value change back to original value. You can also see value in tooltip did not change as well.

Below is my code.

mygrid.cells(id, 10).setValue(obj._Data1);

I also tried to set wasChanged to true. Still no luck.

mygrid.cells(id, 10).cell.wasChanged = true;

I am using row span to show the data on the grid.
Any help would be appreciate. Thank you.

[eiwai]

Hi,

I found out why this happened. I am doing the calculation in onEditCell event. And I also set to call edit on single click. Inside onEditCell event, after update some value on column 1 and column 2, I need to set value for column 3. But column 3 edit event also need to call some calculation method and set value on another column. So my code is as below.

if (stage == 2) {
if ((index == 1) || (index == 2) ) // recalculate data
{
SetValueForColumn3()
}
else if(index==3)
{

     SetValueForColumn4()
  }

}

Then the problem occured. After I tab out from column 2, column 3 value change. But when I tab out from column 3, column 3 value go back to original value.

[sematik]

Unfortunately the problem cannot be reconstructed locally.
Could you please, provide with a more detailed sample or with a simple complete demo where the problem can be reproduced.