[Solved] Merge header columns

[Minkyu Lee]

Hello,

Can I create the following table?

 

 

A	B	C
		D	E			I
			F	G	H

 
I would like to merge some of the columns.

Can you show me a sample code?


Thank you for your help.
Minkyu Lee.

[Shinu]

Hello,


The following documentation shows how to customize the RadGrid header using GridTemplateColumn.
Customizing with GridTemplateColumn

I think, this is what you are searching for.


-Shinu.

[Minkyu Lee]

Wow!! Great.

Thank you Shinu.

I have one more question.

As shown in the table below, can I merge the rows?

 

Singer	Song	C
		D	E			I
			F	G	H
Michael Jackson	Billie Jean
	Thriller
Stevie Wonder	Lately
	Isn't She Lovely
	Superstition

 

[Shinu]

Hello,


It is possible to merge the cells having same values by increasing the RowSpan for the cells. Take a look at the following code.

C#:

protected void RadGrid1_PreRender(object sender, EventArgs e)
{
    for (int rowIndex = RadGrid1.Items.Count - 2; rowIndex >= 0; rowIndex--)
    {
        GridDataItem row = RadGrid1.Items[rowIndex];
        GridDataItem previousRow = RadGrid1.Items[rowIndex + 1];

        for (int i = 0; i < row.Cells.Count; i++)
        {
            if (row.Cells[i].Text == previousRow.Cells[i].Text)
            {
                row.Cells[i].RowSpan = previousRow.Cells[i].RowSpan < 2 ? 2 : previousRow.Cells[i].RowSpan + 1;
                previousRow.Cells[i].Visible = false;
            }
        }
    }
}

In this example, if a cell value is the same as a value in the next (lower) row, then its RowSpan is increased and the lower cell is made invisible.


Happy coding,
Shinu.

[Minkyu Lee]

Thank you Shinu.

[Jason]

Is it possible to achieve the same merged header cells using the WPF Q1 2011 version?

We really need this functionality to manage grids with many columns that really need to be grouped together and still allowed to be sortable.


Thanks

JW