Event after update cell

Aspose.Cells Product Family
1

It’s possible get the event after update cell in yhe webgrid?

thanks

2

Hi,

Thanks for considering Aspose.

Please use OnCellUpdated client -side event which is fired when a cell's value has been changed. Use the GridWeb.OnCellUpdatedClientFunction property to specify the client-side event handler.

Thank you.

3

And in server -side?

4

Hi,

I think you 'd better use onCellUpdated event and perform whatever you want like , retrieving cell value, authenticating validation errors etc. For further ref. please check the source code of "Client Side Scripting" demos in our online demos: Aspose.Grid Demos

Related server-side, there is no such specific event which is directly fired after a cell is updated, CellDoubleClick is there but you can use it to some extent.

Thank you.

5

So i can’t have this event in server-side?

6

Hi,

Currently the control doesn't support cell updated event at server side. The control has an server side event "SheetDataUpdated". This event is fired when the control has updated all the sheet data. You may try to use this event.

Thank you for considering Aspose.

7

If you are storing the data on a database of some sort you can compare the fields in a simple foreach loop after the user submits the sheet ( server-side ).
I use this method to detect what fields where updated and trigger a database update.