Last Updated: 28 Apr 2023 10:05 by Ian
Created on: 28 Apr 2023 10:05
Category: Spreadsheet
Type: Bug Report
Spreadsheet: The UI is not notified when the properties of the WorksheetViewState are changed

At the moment when any of the properties are changed, e.g. the frozen panes, the UI is not notified and you have to export and import the file in order for the UI to pick them up. 

Workaround: There are several workarounds:

1. Change the active worksheet and return to the old one

2. Export and import the document

3. Change the workbook of the RadSpreadsheet to a new one, and return the old one after that

4. Freeze the active worksheet using the ActiveWorksheetEditor.FreezePanes() method and freeze all others using the ViewState:

this.radSpreadsheet1.ActiveWorksheetEditor.FreezePanes(new CellIndex(10, 3));
foreach (var worksheet in this.radSpreadsheet1.Workbook.Worksheets)
      worksheet.ViewState.FreezePanes(5, 5);