I've noticed that when the user performs a 'cut' operation to a row, the spreadsheet's Change event is fired.  However, there doesn't appear to be a way to determine that the range was actually cut - or am I missing something?

Also, when a row deletion happens, the change event isn't fired at all.  This is presenting a problem for me as I have a set of related data on the page that needs to reflect changes as the user modifies the spreadsheet.  Is there a way to effectively catch row deletions?

Hello Sandra,

Indeed, the change event does not provide information about how the change has occurred. Do you need to perform specific actions when the user cuts a selection?

Regarding the row delete -- it should trigger a change event, so this has been logged for fixing.

Hi Alex, thanks for the response.

I just need a means to determine when an insert, delete, or update occurs.  A Cut operation on a whole row is effectively a delete, as far as the data is concerned.  

As a programmer myself, I hate it when people as me this... but... any ETA on the fix being rolled out?  :)

Hello Sandra,

The cut operation will still trigger a change event, so you can detect the cut operation via its range event argument -- if all cells in the range are empty, the row has been deleted. There will be the same outcome if the user hits a delete key, so checking the values will handle this case, too.

As for the change event, we are currently evaluating how to allow detection of the row delete / insert. The change event may need to be triggered with all subsequent data, or we might provide additional events for these actions. We do not have a timeframe for the implementation, but it is likely to happen in future internal builds. We will respond in this thread once this is fixed.