FlexGrid supports merging of cells that have the same content. To enable cell merging, set the AllowMerging property to indicate what part or parts of the grid you want to merge. You can set the AllowMerging property on specific row and column objects. Possible values are None, Cells, ColumnHeaders, RowHeaders, AllHeaders and All.
Once you have set the AllowMerging property to one of these possible values, the FlexGrid automatically merges cells, grouping the data visually.
The following image shows how the FlexGrid appears after setting the AllowMerging property to Cells. The example uses Sale.cs model, which was added to the application in the QuickStart:
The following code examples demonstrate how to enable Merging in the FlexGrid:
MergingController.cs
| C# |
Copy Code
|
|---|---|
public ActionResult MergeCells() { return View(Sales.GetData(15)); } |
|
Merging.cshtml
| Razor |
Copy Code
|
|---|---|
@using MVCFlexGrid.Models
@using C1.Web.Mvc.Grid
@model IEnumerable<Sale>
@(Html.C1().FlexGrid<Sale>()
.AllowMerging(C1.Web.Mvc.Grid.AllowMerging.Cells)
.AutoGenerateColumns(false)
.IsReadOnly(true)
.Bind(Model)
.CssClass("grid")
.Columns(columns =>
{
columns.Add(column => column.Binding("ID").Width("80"));
columns.Add(column => column.Binding("Country"));
columns.Add(column => column.Binding("Product").AllowMerging(true));
columns.Add(column => column.Binding("Color").AllowMerging(true));
columns.Add(column => column.Binding("Amount").Format("c"));
columns.Add(column => column.Binding("Discount").Width("100").Format("p0"));
})
)
|
|
