Using Touch Support with Grouping

You can use touch gestures when grouping.

Tap to select a column, then press down on a column header and slide to the group bar area. Release to create a group. You can also double-tap on a column header to create a group. The following image displays a group.

You can remove the group by dragging the group back to the column header area.

Tap the group header button area to sort.

Using Code

Set the AllowGroup, GroupBarVisible, and AllowColumnMove properties.

Example

This example allows the user to group.

C#	Copy Code
FpSpread1.ActiveSheetView.ColumnHeader.Cells[0, 0].Text = "Last Name"; FpSpread1.ActiveSheetView.ColumnHeader.Cells[0, 1].Text = "First Name"; FpSpread1.ActiveSheetView.Cells[0, 0].Text = "Smith"; FpSpread1.ActiveSheetView.Cells[0, 1].Text = "J"; FpSpread1.ActiveSheetView.Cells[1, 0].Text = "Smith"; FpSpread1.ActiveSheetView.Cells[1, 1].Text = "L"; FpSpread1.ActiveSheetView.AllowColumnMove = true; FpSpread1.ActiveSheetView.GroupBarVisible = true; FpSpread1.ActiveSheetView.AllowGroup = true;

Copy Code

FpSpread1.ActiveSheetView.ColumnHeader.Cells[0, 0].Text = "Last Name";
FpSpread1.ActiveSheetView.ColumnHeader.Cells[0, 1].Text = "First Name";
FpSpread1.ActiveSheetView.Cells[0, 0].Text = "Smith";
FpSpread1.ActiveSheetView.Cells[0, 1].Text = "J";
FpSpread1.ActiveSheetView.Cells[1, 0].Text = "Smith";
FpSpread1.ActiveSheetView.Cells[1, 1].Text = "L";
FpSpread1.ActiveSheetView.AllowColumnMove = true;
FpSpread1.ActiveSheetView.GroupBarVisible = true;
FpSpread1.ActiveSheetView.AllowGroup = true;

VB	Copy Code
FpSpread1.ActiveSheetView.ColumnHeader.Cells(0, 0).Text = "Last Name" FpSpread1.ActiveSheetView.ColumnHeader.Cells(0, 1).Text = "First Name" FpSpread1.ActiveSheetView.Cells(0, 0).Text = "Smith" FpSpread1.ActiveSheetView.Cells(0, 1).Text = "J" FpSpread1.ActiveSheetView.Cells(1, 0).Text = "Smith" FpSpread1.ActiveSheetView.Cells(1, 1).Text = "L" FpSpread1.ActiveSheetView.AllowColumnMove = True FpSpread1.ActiveSheetView.GroupBarVisible = True FpSpread1.ActiveSheetView.AllowGroup = True

Copy Code

FpSpread1.ActiveSheetView.ColumnHeader.Cells(0, 0).Text = "Last Name"
FpSpread1.ActiveSheetView.ColumnHeader.Cells(0, 1).Text = "First Name"
FpSpread1.ActiveSheetView.Cells(0, 0).Text = "Smith"
FpSpread1.ActiveSheetView.Cells(0, 1).Text = "J"
FpSpread1.ActiveSheetView.Cells(1, 0).Text = "Smith"
FpSpread1.ActiveSheetView.Cells(1, 1).Text = "L"
FpSpread1.ActiveSheetView.AllowColumnMove = True
FpSpread1.ActiveSheetView.GroupBarVisible = True
FpSpread1.ActiveSheetView.AllowGroup = True