I'm looking for a way to detect that the user has selected a different sheet (tab) within the spreadsheet control. There doesn't seem to be an event for this action. Is there some other way to detect that the active sheet has been changed?
As background - I'm working on an app for a client in which I've added the spreadsheet control, with several sheets. There's no facility for a custom cell editor (such as a dropdown), but the client is adamant that they want one - they do not want their users typing directly in the cell, but rather, making a selection. I thought a workaround might be to place a dropdown elsewhere on the page, then when the user makes a selection in it, apply the selected text to the currently selected cell on the active sheet. However, I want to hide the dropdown unless the user is on the sheet to which the dropdown actually applies. (I'm also open to any suggestions for a different workaround that doesn't require the user to type out the text themselves.)