How to merge specific Column on GridControl?

[Dhairya Joshi]

Hello Experts, I need advice with GridControl, I want to merge specific column in Grid, for example I've 3 columns 1)Location, 2)Row, 3) Column. Here I want to merge only Location column so that I can see the records only belonging to specific column. I did enabled the GridMergeCellsMode.MergeRowsInColumn BUT it also merges the Row (2nd Column) as well and I dont want that I just want to merge the first column (Ex. Location Only). How can I do that?

My Table Structure is

Location	Row	Column
Bay 1	AB	Container 1
Bay 1	AB	Container 2
Bay 1	AB	Container 3

I just want to merge the First Column "Location" Please give suggetions on this.

[Mohanraj Gunasekaran]

Hi Dhairya, 

Thanks for using the Syncfusion product. 

In order to merge the specific columns, you can use the QueryCanMergeCells event. Please refer to the below code example and the attached sample, 

 

Code example 

this.gridControl1.Model.QueryCanMergeCells += Model_QueryCanMergeCells; 

 

void Model_QueryCanMergeCells(object sender, GridQueryCanMergeCellsEventArgs e) 

{ 

    if (e.Style1.CellIdentity.ColIndex != 1) 

        e.Handled = true; 

} 

Sample link: GridControl 

Regards, 

Mohanraj G 

[Dhairya Joshi]

Thanks It Worked !

[Mohanraj Gunasekaran]

Hi Dhairya, 

Thanks for your update. 

We are glad to know that your reported problem has been resolved. 

Please let me know, if you have any concerns. 

Regards, 

Mohanraj G