I have an application with the sfspreadsheetcontrol. I load an excel-file with multiple worksheets. The active sheet at start is the firsdt worksheet which is also displayed in the control. Now I need to switch by code to another worksheet, so that the user sees those new worksheet (e.g. because as a result of a search, I know that the wanted cell is on sheet 2).
I can change the active sheet: spreadsheetControl.ActiveSheet = spreadsheetControl.Workbook.Worksheets[worksheetname];
Now the active sheet has changed, but still the old worksheet is displayed by the control. I have tried something like: spreadsheetControl.ActiveSheet.Activate();
KBKanimozhi Bharathi Syncfusion Team April 26, 2016 12:37 PM UTC
Thank you for contacting Syncfusion Support.
We have added a new method “SetActiveSheet(“SheetName”) to set the active worksheet in SfSpreadsheetand this method will be included in 2016Vol1 SP1 release which will be rolled out by the end of this month.