Unplanned
Last Updated: 31 Oct 2018 13:43 by ADMIN
ADMIN
Nikolay Demirev
Created on: 02 Jun 2016 11:04
Category: Spreadsheet
Type: Bug Report
3
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:

RadWorksheetEditor editor = this.radSpreadsheet.ActiveWorksheetEditor;
editor.FreezePanes(new CellIndex(3,3));
foreach (var worksheet in this.radSpreadsheet.Workbook.Worksheets)
{
    worksheet.ViewState.FreezePanes(5, 5);
}
2 comments
ADMIN
Tanya
Posted on: 31 Oct 2018 13:43
Hi Steve,

Thank you for your feedback. The issue is included in our prioritization and planning processes and we agree that the behavior is not correct and should be fixed. However, it is not scheduled at this point, and I cannot commit to a particular timeframe when a fix might be available.

All the known issues and feature requests, as well as the available workarounds, are present and described in this portal. In case there is some specific behavior that we don't have plans to change, it will be included in the documentation.

Regards,
Tanya
Steve
Posted on: 17 Oct 2018 10:28
These workarounds should be explained in the documentation if the bug is not going to be fixed