Spreadsheet versus Grid component

4 posts, 0 answers
  1. Hui
    Hui  avatar
    2 posts
    Member since:
    Aug 2013

    Posted 28 Nov 2015 Link to this post

    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
  2. Bozhidar
    Admin
    Bozhidar avatar
    1103 posts

    Posted 02 Dec 2015 Link to this post

    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
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Hui
    Hui  avatar
    2 posts
    Member since:
    Aug 2013

    Posted 02 Dec 2015 in reply to Bozhidar Link to this post

    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. 
  5. Bozhidar
    Admin
    Bozhidar avatar
    1103 posts

    Posted 03 Dec 2015 Link to this post

    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
Back to Top