Rank 1
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?
3 Answers, 1 is accepted
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.
Regards,Alex Gyoshev
Telerik
Rank 1
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.
Regards,Alex Gyoshev
Telerik