List<Customer> list = new List<Customer>();
list.Add(new Customer() { Name = "Nancy", Country = "Japan", City = "Tokyo" });
list.Add(new Customer() { Name = "Janet", Country = "Japan", City = "Sendai", });
list.Add(new Customer() { Name = "Rose", Country = "Japan", City = "Tokyo", });
list.Add(new Customer() { Name = "Buchanan", Country = "Japan", City = "Osaka", });
list.Add(new Customer() { Name = "Leverling", Country = "Japan", City = "Tokyo", });
list.Add(new Customer() { Name = "Gavin", Country = "China", City = "Beijing", });
list.Add(new Customer() { Name = "Victoria", Country = "China", City = "Xi'An", });
list.Add(new Customer() { Name = "Apple", Country = "China", City = "Beijing", });
list.Add(new Customer() { Name = "Tim", Country = "China", City = "Beijing", });
list.Add(new Customer() { Name = "John", Country = "China", City = "Xi'An", });
gcSpreadGrid1.ItemsSource = list;
Column column1 = gcSpreadGrid1.Columns["Country"];
GroupCell headerCell = column1.GroupHeader[0, 0];
headerCell.ColumnSpan = int.MaxValue;
headerCell.Background = Brushes.Azure;
headerCell.Formula = @"GroupInfo(""groupBy"") & "": "" & GROUPINFO(""groupText"")";
column1.GroupFooter.RowCount = 1;
column1.GroupFooter.Rows[0].Background = Brushes.LightBlue;
GroupCell footerCell1 = column1.GroupFooter[0, 0];
footerCell1.Value = "Count: ";
footerCell1.ColumnSpan = gcSpreadGrid1.ColumnCount - 1;
GroupCell footerCell2 = column1.GroupFooter[0, gcSpreadGrid1.ColumnCount - 1];
footerCell2.AggregationType = AggregationType.Count;
SpreadGroupDescription groupDescription = new SpreadGroupDescription();
groupDescription.ColumnName = "Country";
gcSpreadGrid1.GroupDescriptions.Add(groupDescription);
Dim list As New List(Of Customer)()
list.Add(New Customer() With { _
.Name = "Nancy", _
.Country = "Japan", _
.City = "Tokyo" _
})
list.Add(New Customer() With { _
.Name = "Janet", _
.Country = "Japan", _
.City = "Sendai" _
})
list.Add(New Customer() With { _
.Name = "Rose", _
.Country = "Japan", _
.City = "Tokyo" _
})
list.Add(New Customer() With { _
.Name = "Buchanan", _
.Country = "Japan", _
.City = "Osaka" _
})
list.Add(New Customer() With { _
.Name = "Leverling", _
.Country = "Japan", _
.City = "Tokyo" _
})
list.Add(New Customer() With { _
.Name = "Gavin", _
.Country = "China", _
.City = "Beijing" _
})
list.Add(New Customer() With { _
.Name = "Victoria", _
.Country = "China", _
.City = "Xi'An" _
})
list.Add(New Customer() With { _
.Name = "Apple", _
.Country = "China", _
.City = "Beijing" _
})
list.Add(New Customer() With { _
.Name = "Tim", _
.Country = "China", _
.City = "Beijing" _
})
list.Add(New Customer() With { _
.Name = "John", _
.Country = "China", _
.City = "Xi'An" _
})
gcSpreadGrid1.ItemsSource = list
Dim column1 As Column = gcSpreadGrid1.Columns("Country")
Dim headerCell As GroupCell = column1.GroupHeader(0, 0)
headerCell.ColumnSpan = Integer.MaxValue
headerCell.Background = Brushes.Azure
headerCell.Formula = "GroupInfo(""groupBy"") & "": "" & GROUPINFO(""groupText"")"
column1.GroupFooter.RowCount = 1
column1.GroupFooter.Rows(0).Background = Brushes.LightBlue
Dim footerCell1 As GroupCell = column1.GroupFooter(0, 0)
footerCell1.Value = "Count: "
footerCell1.ColumnSpan = gcSpreadGrid1.ColumnCount - 1
Dim footerCell2 As GroupCell = column1.GroupFooter(0, gcSpreadGrid1.ColumnCount - 1)
footerCell2.AggregationType = AggregationType.Count
Dim groupDescription As New SpreadGroupDescription()
groupDescription.ColumnName = "Country"
gcSpreadGrid1.GroupDescriptions.Add(groupDescription)