This is a migrated thread and some comments may be shown as answers.

Spreadsheet versus Grid component

3 Answers 88 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Hui
Top achievements
Rank 1
Hui asked on 28 Nov 2015, 04:54 PM
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

Sort by
0
Bozhidar
Telerik team
answered on 02 Dec 2015, 09:23 AM
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
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
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
Bozhidar
Telerik team
answered on 03 Dec 2015, 08:04 AM
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
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
Tags
Spreadsheet
Asked by
Hui
Top achievements
Rank 1
Answers by
Bozhidar
Telerik team
Hui
Top achievements
Rank 1
Share this question
or