Please refer to the attached gif file.
This is the sample code snippet:
public RadForm1()
{
InitializeComponent();
this.radSpreadsheet1.SpreadsheetElement.ActiveWorksheetEditor.MouseClick += ActiveWorksheetEditor_MouseClick;
}
private void ActiveWorksheetEditor_MouseClick(object sender, Telerik.WinControls.Spreadsheet.UI.MouseButtonEventArgs e)
{
Console.WriteLine(DateTime.Now.ToLongTimeString());
var selection = this.radSpreadsheet1.SpreadsheetElement.ActiveWorksheetEditor.Selection.ActiveRange;
if (!selection.IsColumnRange)
{
}
}
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);
}
In Material(Pink,Teal,BlueGrey) themes, the row heading numbers are truncated.
Clicking on a calculated cell leads to the following error and crashes the demo:
Import the attached sample file, right-click on the first cell and select Format Cell:
Expected result: correct cell style should be loaded as it is MS Excel:
Import the attached document:
Expected result: the cell B1 should be rendered with bold text as in MS Excel:
Currently, it takes around 5 seconds to load the RadSpreadsheetRibbonBar.
Please run the project and compare the load time when clicking the two buttons in the main form.
Please follow the steps in the VS Designer:
1. Add a RadSpreadsheet and Office2019Dark theme:
2. Set the ThemeName for RadSpreadsheet to Office2019Dark:
3. Run the project. You will see that the row/column headers are not readable:
4. Stop the project and reopen the designer:
When the HorizontalAxisStroke is not specified, an error occurs during the document's loading.
Import the attached document in RadSpreadsheet:
Expected result: centered text like in MS Excel:
Import the attached document and zoom in/out:
Expected result: the whole text should be fully visible like in MS Excel:
Filter buttons are not hidden when a column is hidden
Workaround in the attached project.