I have same requirement with multiple rows were copied back from excel and when pasted by focusing grid or at the last “empty” row, automatically append all the new rows. It could even handle mixed scenarios. Where if your cursor was on an existing row in the grid, the paste would overwrite any existing records and if it hit the bottom of the grid, the paste would then would continue by appending the remaining rows to the end of the grid.
Am I missing the trick to adding new rows automatically? and is there a way I can handle these scenarios?
And yes our organisation is using paid version. Thanks in advance.
You could use the cellclick event or also the rowclick event to recognize on which row is the cursor.
Also, the handlekeyboardnavigation callback could be helpful here.
Another thing that you should handle is to process the copied data to know how many rows to add or on which rows to add this data.
As in the mentioned topic, I would like to suggest you contact the Support Team(firstname.lastname@example.org) or the Sales Department(email@example.com) with your request.