Can i get an event for insert row, delete row, show & hide row in the spreadsheet.

Hello,
I’m looking for an event which can listen to row changes such as insert/delete rows so that i can accordingly make changes to my table structure
Thank you,

You can use onRowOperation and onColumnOperation. Both events receive the following parameters. For example, in case of deleting row:

  • action (obj) : selected action
    {id: "del", group: "row", value: "Delete row"}
  • start (obj) : start cell
    {row: 10, column: 1}
  • end (obj) : end cell
    {row: 10, column: 20}

Whats are the events for that onRowOperation and onColumnOperation?

These events are called on any operation listed here. They are available in the UI as options of the row/column context menu.