How to set a new value to a other cell within cellvaluechanged event .

[MaheshParticipant]

Hello,

How to set a new value to a other cell within the cellvaluechanged event without triggering it again.

I tried both the options (setcellvalue and setcellvaluebyid)

Following line changes a other cell’s value but cellvaluechanged event is triggered once more when a cell’s value is changed.
$(“#jqxGrid”).jqxGrid(‘setcellvalue’, 0, “firstname”, “New Value”);

Following line doesn’t change a other cell’s value so don’t know the cellvaluechanged event will be triggered or not when a cell’s value is changed.
$(“#jqxGrid”).jqxGrid(‘setcellvaluebyid’, id1, “firstname”, “New Value”);

Regards,

Mahesh

[MartinParticipant]

Hello Mahesh,

You can use a flag to check whether the change is triggered by the cellvaluechanged event or not.
Here is an Example.

Best Regards,
Martin Yotov

jQWidgets team
https://www.jqwidgets.com

[MaheshParticipant]

Hello Martin,

I went through your example.
Apparently it seems to be working, but I could not understand the logic.
Please explain it in a very simple way.

Regards,

Mahesh

[MaheshParticipant]

Hello Martin,

I also want to know whether setcellvalue method triggeres cellvaluechanged event or cellendedit event.

Regards,

Mahesh.

[MartinParticipant]

Hello Mahesh,

Before we start updating the cells we initialize a boolean variable changeTriggeredFromEvent with value “false”.
Then when we call the setcellvalue method and the cellvaluechanged event is triggered we set changeTriggeredFromEvent to true before updating another cell. So the next time that cellvaluechanged is triggered the changeTriggeredFromEvent variable is “true” and we know that this change comes from the event handler so we just set it to “false” again and exit the function without doing another cell update.

setcellvalue triggers only the cellvaluechanged event.

Best Regards,
Martin Yotov

jQWidgets team
https://www.jqwidgets.com

[MaheshParticipant]

Thanks Martin for the nice explanation.
Regards,
Mahesh

[Author]

Posts