Need activeSheet name after new sheet selected for kendoSpreadsheet control

[George]

Hi,

Was wondering if there is a way to get the actual active sheet as soon as it is selected. the selectSheet handler will access the previous sheet and its properties:

 

Is there a later event that will allow me to grab the activeSheet and tap into its properties? I am trying to get the sheet name, so I can cross reference it against a data source. but I need this info prior to someone selecting a cell (prior to a change event or accessing the change event handler) on the newly selected active sheet.

I need to grab the activeSheet as soon as the sheet is selected... I need to get the actual sheet that was selected on the event and NOT the previous sheet. Apparently activeSheet is updated after the selectSheet event. If I try to do this on the change event, it slows things down on the selection of the cell I am editing.

Thanks!

George

 

[Martin]

Hello, George,

In the selectSheet event, you have the e.sheet parameter which is the sheet that will be activated, and not the previously selected one. Would that be useful for your requirement? Here's a small example for reference.

Regards,
Martin
Progress Telerik

[George]

Martin,

Yes I think this will work. Tried the demo. Nice.

Thanks!

George