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.

Hello,

 

I have a RadRibbonForm with a normal ribbon with no items and a spreadsheet control.

 

I iterate over a datatable and fill the spreadsheet's cell values with the datatable's values

we're talking about a very small size, like 33 rows x 35 columns, and not even all the values are filled in.

 

Unfortunately, there's a very noticeable delay in the spreadsheet, from moving the scrollbars to selecting to changing sheets.. the whole thing feels laggy.

Is this just how it is, or am I experiencing a possible bug?

Could it have anything to do with https://feedback.telerik.com/winforms/1380948-exception-at-runtime-trial-bug ?

 

If that is just how it is, is there anything I can do to make it feel snappier? Disable a theme? Disable some behaviour?

The list data validation rule allows you to restrict the user input to a predefined set of values: https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/data-validation#list-rule 

At this point, character formatting can be applied only to the whole cell content. Enable applying rich text formatting only to parts of the text inside a cell.

Add support for conditional formatting 

If a worksheet spans more than one page, you can print row and column headings or labels (also called print titles) on every page to ensure that the data is properly labeled.

Currently if radSpreadsheet RightToLeft property is set to Yes, only the Formula Bar is affected; RadSpreadSheet and Status Bar are not.

Introduce support for Spell Check

Users want to save the workbook via the Save ribbon button, but they want a default filename in the save dialog (not "book1.xlsx"). 

MS Excel has this splitter functionality: 

In Material(Pink,Teal,BlueGrey) themes, the row heading numbers are truncated.

More information is available here: 

https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/notes

https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/comments 

 

If you load the attached document in RadSpreadsheet and select the first cell A1, the yellow popup doesn't occur even though it is defined in the document:

Expected result:

Like in WPF RadSpreadsheet:

Like in MS Excel:

 

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:

In Excel, the cursor changes to look like <-I-> when it is in the correct position to start resizing (column or row), and stays the same when the user is doing the resize - good visual feedback.

In RadSpreadsheet, we get a similar <-I-> cursor when in position to re-size, but this goes away (back to the normal pointer) whilst the user is re-sizing. The re-size operation works just fine, but I don't get the feedback whilst doing it.

Please refer to the two gif files illustrating the behavior in MS Excel and in RadSpreadsheet.

Exception when copying sheet with conditional formatting and opening it in RadSpreadsheet