Merge cells across rows in RadGridView

14 posts, 1 answers
  1. Nasir
    Nasir avatar
    18 posts
    Member since:
    Apr 2013

    Posted 16 Apr 2013 Link to this post

    Hi,

    Is it possible to merge multiple cell across multiple rows based on a particular value? For example 


    Column 1 Column 2

    Row1 Dell XPS12
    Row2 Dell Inspiron
    Row3 Dell XPS 15

    Should be shown as:

    Column 1 Column 2

    Row1 XPS12
    Row2 Dell Inspiron
    Row3 XPS 15

    I know I have seen in some forums that it is not supported but I desperately need this functionality in the GridView. Is there a workaround for this? Is there any other control that I can use instead of RadGridView?

    I would really really appreciate a quick response.

    Regards

    Nas.
  2.
  3. Answer
    Dimitrina
    Admin
    Dimitrina avatar
    3769 posts

    Posted 16 Apr 2013 Link to this post

    Hello,

    This feature is still not supported from RadGridView. We will plan it after the Q2 version is released, however, we cannot commit to a specific time when it will be ready. It is added as feature request in our PITS and you can vote for it here.

    I am afraid that currently we cannot suggest any workaround or solution for merging cells in RadGridView.

    Regards,
    Didie
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  5. Nasir
    Nasir avatar
    18 posts
    Member since:
    Apr 2013

    Posted 16 Apr 2013 Link to this post

    Hi Didie,

    Thanks for getting back so quickly. That is so disappointing but I understand that there may not be as much demand for this functionality.

    Regards,


    Nas
  7. svs
    svs avatar
    5 posts
    Member since:
    Sep 2007

    Posted 28 May 2013 Link to this post

    For what it's worth, I'd like this functionality too!

    Good to hear that it's on its way (I do understand that you can't commit to a time).

    My use case is slightly different:
    Period Block Block price HH Price
    1 1 b1 p1
    2 1 b1 p2
    3 1 b1 p3
    ...
    9 2 b2 p7
    Each half hour of a day has a different price. A day is split up into 4 hour blocks, each block has its own proce.
    I'd like to merge the 8 rows each block covers - both the Block and Block Price columns. That is merge the Block column based on its contents, and merge the Block Price column based on the Block column's contents.

    Thanks! -
  8.
  9. Nasir
    Nasir avatar
    18 posts
    Member since:
    Apr 2013

    Posted 28 May 2013 Link to this post

    Hi svs,

    I am not sure if I can quote but I have been looking at other controls from ComponentOne. Their Data Grid has the exact merge functionality that I need.

    I am still waiting on Telerik to release something but in the next month we would consider using ComponentOne for this particular project to achieve the functionality we get.

    It is a shame that Telerik controls are really powerful but has this functionality missing which to be honest is an expected functionality.

    Regards,

    Nasir
  11. Dimitrina
    Admin
    Dimitrina avatar
    3769 posts

    Posted 29 May 2013 Link to this post

    Hello,

    Thank you for your feedback. We will take it into account. 

    Regards,
    Didie
    Telerik

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  13. FTI Dev
    FTI Dev avatar
    3 posts
    Member since:
    Sep 2007

    Posted 07 Aug 2014 in reply to Dimitrina Link to this post

    Will you please provide an update as to whether Telerik has addressed the merge cells feature.  I have looked at the release notes and don't see anything in the second half of 2013 or 2014 to date that references this feature request.  Please advise as we could really use this feature.
  14.
  15. Ivan Ivanov
    Admin
    Ivan Ivanov avatar
    1219 posts

    Posted 11 Aug 2014 Link to this post

    Hello,

    We have officially scheduled this feature for Q3 2014 and we are currently working on the implementation. We initially plan to introduce vertical auto-merge for cells that have the same value. We will possibly introduce horizontal auto-merge with Q3, or a bit later, as we currently treat the vertical scenario as the more important one. Can you please, share what type of scenarios you plan to handle with merged cells and whether an auto-merge feature would fit your needs?

    Regards,
    Ivan Ivanov
    Telerik
     
    Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
     
  17. FTI Dev
    FTI Dev avatar
    3 posts
    Member since:
    Sep 2007

    Posted 13 Aug 2014 in reply to Ivan Ivanov Link to this post

    Hi Ivan,

    Thank you for the update.  We are very much looking forward to this feature.

    Yes, we intend to use vertical merge and do not currently have the need for horizontal.  Our use involves names of insurance policyholders and their respective policy numbers.  There will be multiple rows when a policyholder has multiple policies (home, auto, valuable articles, umbrella, etc).  We are currently showing a grid with as many rows as the policyholder has policies.  We however only have one policyholder (Insured) record and the policies are one-to-many relationship in another database table.  To repeat the Insured/Policyholder name on every row makes it appear to the user that there are several insureds/policyholders rather than one with multiple policies.  If we can merge the vertical where the InsuredID (a non-displayed column of the recordset) is the same then we can provide a much more intuitive user interface/experience.

    To answer your question about auto-merge, I am not sure that would be best for us, as we would like to have an "action/options" cell to the left of the Insured/Policyholder name that would allow us to edit, copy, and delete.  Currently there are as many of these action/option icons as there are rows.



  19. Ivan Ivanov
    Admin
    Ivan Ivanov avatar
    1219 posts

    Posted 18 Aug 2014 Link to this post

    Hello,

    Currently, the Spreadsheet control from our suite supports merged cells that are not automatically generated. However, your description implies that you want a data bound control so Spreadsheet may not be the best option. 
    Basically, we plan to have a column property that controls the vertical auto-merge behavior column-wise. You can have columns that auto-merge alongside others that display all the cells. Thus, you will be able to display a separate cell for each record for the copy/paste/delete options. Does such a property makes sense for your scenario?

    Regards,
    Ivan Ivanov
    Telerik
     
    Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
     
  20.
  21. WK
    WK avatar
    1 posts
    Member since:
    Oct 2014

    Posted 29 Oct 2014 Link to this post

    Hi,

    For my application I am currently evaluating the Telerik WPF controls. I need the 'horizontal merge' feature (in the RadTreeListView btw). Is there any news on this topic?
    Attached is an example of how I would like the tree list to look.

    Thanks,
    WK
  23. Dimitrina
    Admin
    Dimitrina avatar
    3769 posts

    Posted 29 Oct 2014 Link to this post

    Hi,

    As of Q3 2014 we introduced support for merged cells in RadGridView control. As a result the serial cells with equal values can be merged vertically or horizontally. You can also check our documentation on Merged Cells.
    When it comes to RadTreeListView, there is still not such a support. We are working towards extending this control also, still, please keep in mind that most probably the expand column will be excluded of the merging.

    Regards,
    Dimitrina
    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.

     
  25. Patrick
    Patrick avatar
    59 posts
    Member since:
    Jan 2013

    Posted 14 Apr 2015 in reply to Dimitrina Link to this post

    +1 on having this feature in RadGridView for Silverlight. MergedCellsDirection="Vertical" would be great. I noticed from the WPF version that frozen columns are not supported. For us vertical merged cells with frozen columns would be ideal. I understand these things aren't easy, I just wanted to put the vote in. If there is a better place to 'up vote', please direct me.

     Thanks,

    Patrick

  26.
  27. Dimitrina
    Admin
    Dimitrina avatar
    3769 posts

    Posted 14 Apr 2015 Link to this post

    Hi Patrick,

    Thank you for sharing your valuable feedback.

    Regards,
    Dimitrina
    Telerik
     

    See What's Next in App Development. Register for TelerikNEXT.

     
Back to Top