开发者

In GoogleApp Spreadsheet, how do I make onEdit event handler react to drag copying?

开发者 https://www.devze.com 2023-03-05 14:51 出处:网络
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\'.

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

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号