One way to achieve this is to freeze the active worksheet, the way you are doing it right now, using the RadWorksheetEditor.FreezePanes() method, then to iterate through all worksheets in the workbook and modify their ViewState using the following code:
workbook.Worksheets.Where(p => p != workbook.ActiveWorksheet))
Currently, there is an issue related to notifying the UI of changes in the ViewState of the worksheet, that is why the active worksheet has to be frozen using a different approach.
Another workaround is to get the Workbook of the RadSpreadsheet, and replace it with new Workbook, then freeze all worksheets of the original workbook, and return it to the RadSpreadsheet.
Another workaround is to freeze all worksheets, and just change the active worksheet to another one, and then to the one, which was active before.
I have logged a public item in our Feedback portal
, you can upvote and follow it, this way you would be able to track the process on the matter.
Do you need help with upgrading your AJAX, WPF or WinForms project? Check the Telerik API Analyzer
and share your thoughts.