We need to do some format change operation only for pasted data which is copied from other spreadsheet. That format change is not applicable for manually written data We have tried to distinguish pasted data from manually written data in 'Change' event of spreadsheet but could not find any clue.
3 Answers, 1 is accepted
answered on 08 Jun 2017, 07:45 AM
There isn't a built-in method that allows to differentiate pasted from typed data. You could use jQuery to detect pasting in the Spreadsheet, then get the selected range and format it. See this dojo for example.
Thanks Ivan for your reply. But I think there is a problem with selection() method of sheet. It actually returns single row and single column though there are multiple selected rows and columns present. That's why only first cell is getting updated instead of every rows and columns. Please refer to the screenshot of the dojo.
answered on 16 Jun 2017, 11:43 AM
You are correct, that the selection() method in this scenario would return only the top-left pasted cell. In order to cover the case with pasting multiple cells, I would suggest you to implement a handler for the change event: