Merge cells across rows in RadGridView

[Nasir]

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.

[Dimitrina]

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

[Nasir]

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

[svs]

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! -

[Nasir]

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

[Dimitrina]

Hello,

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

Regards,
Didie
Telerik

[FTI Dev]

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.

[Ivan Ivanov]

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

 

 

[FTI Dev]

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.

[Ivan Ivanov]

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

 

 

[WK]

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

[Dimitrina]

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

 

 

[Patrick]

+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

[Dimitrina]

Hi Patrick,

Thank you for sharing your valuable feedback.

Regards,
Dimitrina
Telerik