Sheet: Change event not always fired on multi update
Posted: 10 Oct 2018, 14:37
The change event is not allways fired when the changes are made via "Autofill.fill".
You can see this in action in the showcase - Basic usage.
If you change the contents of a cell (e.g. one in the date column in the showcase), and before anything else, you drag that cell down to change the cells below to get the same content you changed the first cell to, then the cells will get the new content but the change event is only fired for the original cell.
You can verify that in 2 ways:
1. the showcase says: 1 rows updated, which should be at least more than one.
2. change the contents of a cell on the same row as one of the supposidly changed cells. The supposidly changed cell (in the date column in my example) will change back to it's original content.
It's a bit hard to explain but I hope this is clear.
You can see this in action in the showcase - Basic usage.
If you change the contents of a cell (e.g. one in the date column in the showcase), and before anything else, you drag that cell down to change the cells below to get the same content you changed the first cell to, then the cells will get the new content but the change event is only fired for the original cell.
You can verify that in 2 ways:
1. the showcase says: 1 rows updated, which should be at least more than one.
2. change the contents of a cell on the same row as one of the supposidly changed cells. The supposidly changed cell (in the date column in my example) will change back to it's original content.
It's a bit hard to explain but I hope this is clear.