Do you want to: Report a bug
We tried using attachEvent in the SpreadsheetAPI to listen for the onWorksheetChange event, but we found that when users select data from a dropdown list, the onWorksheetChange event is not triggered. This appears to be a bug, or are we using it incorrectly?
Document Server version: 9.0.2.1
os: windows11
this is my drop down.when i select one，the event can not be triggered.
Thank you for your attention to this issue. We appreciate your support and look forward to your response.
Hello @guochongjin
I’ve checked the scenario, the macro works when you’re changing data in the cell as shown by console.log("onWorksheetChange");
Do I understand it right that you need to listen event of selecting from drop-down menu, but not just cell changes?
Sorry for the late reply. Your understanding later is correct – we wanted to monitor selections from dropdown lists, as we consider them a type of cell change. However, based on our current API testing, this doesn’t seem to be the case.**
I tried to upload a video (to demonstrate the issue), but the system informed me that new users aren’t allowed to attach files.
Hello @guochongjin
Understood, we need some time to check it out. I will contact you shortly.
Hello, could you please share if any conclusions have been reached on this issue?
Hello,
We are still working on it. I will contact you as soon as possible.