How to rename a worksheet in RadSpreadsheet in Winforms

[Doug]

Hello,

I am doing the following to rename a worksheet:

                Worksheet workSheet = sheetReturns.SpreadsheetElement.Workbook.Sheets.Add(SheetType.Worksheet) as Worksheet;
                workSheet.Name = "Missing Top 100";
                dtProvider.Import(_missingTop100, workSheet);
                sheetReturns.SpreadsheetElement.Workbook.ActiveWorksheet = workSheet;
                workSheet.Columns[workSheet.UsedCellRange].AutoFitWidth();

The new name of the sheet does not show unless another worksheet is added or I double click on the worksheet tab.

How can I code this so the new name shows immediately?

Thanks,
Doug

 

[Dess | Tech Support Engineer, Principal]

Hello, Doug,

It seems that you hit a known issue which fix is expected to be released in the upcoming R3 2021 scheduled for the middle of September. Here is the feedback item for your reference:

https://feedback.telerik.com/winforms/1384925-changing-sheet-name-at-runtime-doesn-t-update-name

Meanwhile, feel free to use the suggested solution with using the RenameSheetCommand: 

//make active the sheet that you want to rename
this.radSpreadsheet1.ActiveSheet = this.radSpreadsheet1.Workbook.Sheets[1];
this.radSpreadsheet1.SpreadsheetElement.SheetSelector.RenameSheetCommand.Execute("new name")

I hope this information helps. If you need any further assistance please don't hesitate to contact me. 

Regards,
Dess | Tech Support Engineer, Principal
Progress Telerik