An example that demonstrates how to achieve excel-like functionality for the grid is available in the code library below:
Regarding your other questions:
- read only cells (the ones with the formulas)
You can subscribing to ItemCreated event access the desired cells(with the formulas)and make the cell not editable for the customers. A similar example that shows hot to make certain cell read only is available here:
- frozen columns on the left and right
Currently RadGrid only supports frozen columns on the left side. Sorry for the inconvenience caused.
- frozen header rows
In order to make the grid headers frozen you can set ClientSettings.Scrolling.UseStaticHeaders property to True.
- excel import and export
Export to excel demo for RadGrid control is available here:
Unfortunately, RadGrid does not support importing data from Excel. Nevertheless you could check out the following project where is demonstrated a possible way to import Excel data to grid.
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Telerik Feedback Portal
and vote to affect the priority of the items