Exploring the new spreadsheet component and it sounds very promised to one of my upcoming project. The customer has an excel data sheet with many scientific formulas built-in. I want to build an excel template based on its original formula (locking the formula column) and bind the data with a table in the SQL database. Can you advise if this new component is better than Grid component for this purpose? Do you have any example to follow? Thanks
3 Answers, 1 is accepted
0
Hi,
If you want to work with a SQL Database, then the Grid will be better suited for your scenario, since it has full integration with all ASP.NET datasource components (for instance SqlDataSource etc.), with batch editing, inline editing and many more features coming out of the box.
The Spreadsheet on the other hand is designed to work through providers, with the SpreadsheetDocumentProvider being currently provided out of the box. This provider is designed to work directly with an excel file. The Spreadsheet is currently in its beta release, with the official being scheduled for mid January 2016, where additions like Improved Toolbar, Context Menu, Filter Menu and others.
The choice is up to the developer. For a reference of the available features of both controls you can go to our online demos and documentation:
http://demos.telerik.com/aspnet-ajax/
http://docs.telerik.com/devtools/aspnet-ajax/introduction
Regards,
Bozhidar
Telerik
If you want to work with a SQL Database, then the Grid will be better suited for your scenario, since it has full integration with all ASP.NET datasource components (for instance SqlDataSource etc.), with batch editing, inline editing and many more features coming out of the box.
The Spreadsheet on the other hand is designed to work through providers, with the SpreadsheetDocumentProvider being currently provided out of the box. This provider is designed to work directly with an excel file. The Spreadsheet is currently in its beta release, with the official being scheduled for mid January 2016, where additions like Improved Toolbar, Context Menu, Filter Menu and others.
The choice is up to the developer. For a reference of the available features of both controls you can go to our online demos and documentation:
http://demos.telerik.com/aspnet-ajax/
http://docs.telerik.com/devtools/aspnet-ajax/introduction
Regards,
Bozhidar
Telerik
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?
Explore the
Telerik Feedback Portal
and vote to affect the priority of the items
0
Hui
Top achievements
Rank 1
Rank 1
answered on 02 Dec 2015, 05:47 PM
Thanks for the reply. OK, it looks like that we will go with RadGrid control. My dilemma is how to allow the authorized users to update the formula (e.g., a1+b1). Any advice will be appreciated.
0
Hi,
Working with authentication in ASP.NET Ajax is a common coding conundrum, and we can't offer any consulting on the matter. If you encounter any issues using the RadGrid control along the way, we would be happy to help you resolve them.
Regards,
Bozhidar
Telerik
Working with authentication in ASP.NET Ajax is a common coding conundrum, and we can't offer any consulting on the matter. If you encounter any issues using the RadGrid control along the way, we would be happy to help you resolve them.
Regards,
Bozhidar
Telerik
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?
Explore the
Telerik Feedback Portal
and vote to affect the priority of the items