I want to implement a feature,Listen for changes in one range and assign values to another range.
My implementation steps:
1.Use the onChanged event to listen for changes to the data.
2.Assign the changed value【event.details.valueAfter】 to the target range in the callback function.
This is my code: https://i.stack.imgur.com/lealz.png
But the console will show that it ran the callback many times,This is the console log: https://i.stack.imgur.com/SS941.png
Is there something wrong with my code?Is there a good solution?