Does RadGrid support formulas

2 posts, 0 answers
  1. Bradley
    Bradley avatar
    3 posts
    Member since:
    Jul 2011

    Posted 11 Apr 2014 Link to this post

    I need a grid that supports formulas in cells like Excel does.  I also need 
     - read only cells (the ones with the formulas)
     - frozen columns on the left and right
     - frozen header rows
     - excel import and export

    Does the RadGrid support this?
  2. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 14 Apr 2014 Link to this post

    Hi Bradley,

    An example that demonstrates how to achieve excel-like functionality for the grid is available in the code library below:
    http://www.telerik.com/support/code-library/excel-look-and-feel-for-radgrid

    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:
    http://www.telerik.com/help/aspnet-ajax/grid-read-only-mode-for-individual-cells.html

     - 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:
    http://demos.telerik.com/aspnet-ajax/grid/examples/functionality/exporting/excel-export/defaultcs.aspx

    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. 

    Regards,
    Pavlina
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
Back to Top