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
    Pavlina avatar
    6187 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:

    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? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top

This Code Library is part of the product documentation and subject to the respective product license agreement.