In GoogleApp Spreadsheet, how do I make onEdit event handler react to drag copying?
My onEdit event handler fires just fine when I edit spreadsheet cell manually, or when I paste into it by Ctrl+V, but completely ignores when I do 'drag-copying'.
'drag-copying' is when you point the mouse to cell's lower right corner, the one marked with little square, then hold left mouse button down, then move the mouse down. When you do so, Spreadsheet will copy cell's value to every cell below, down to mouse pointer's current position.
I want my code in onEdit event handler to process every change of cell values.
But it doesn't gets called at all!
Please point me to how to do it right or tell me开发者_C百科 it's not possible.
This is a known bug and has been reported on Apps Script Issue Tracker
So, to answer your question: No, it is not currently possible.
Best, Anton
精彩评论