Creating Cell Spans

In This Topic

You can create a cell span in the cell, row header, or column header area. You can also remove or clear cell spans.

The entire span is treated as an active cell when using the Tab key to move the active cell to the spanned cell. The active cell outline includes the entire span.

The following image displays a span in the cell and header areas:

Cell span in cell and header areas of the spreadsheet

You can use the AddSpanCell, ClearSpanCells, or RemoveSpanCell method in code.

Using Code

The following example uses the AddSpanCell method to create a cell span.

CS	Copy Code
GrapeCity.Windows.SpreadSheet.Data.CellRange r; r = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 3, 3); gcSpreadSheet1.Sheets[0].AddSpanCell(r, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells); gcSpreadSheet1.Sheets[0].RowHeader.ColumnCount = 2; gcSpreadSheet1.Sheets[0].ColumnHeader.RowCount = 2; GrapeCity.Windows.SpreadSheet.Data.CellRange r2; r2 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 2, 2); gcSpreadSheet1.Sheets[0].AddSpanCell(r2, GrapeCity.Windows.SpreadSheet.Data.SheetArea.RowHeader); gcSpreadSheet1.Invalidate();

Copy Code

GrapeCity.Windows.SpreadSheet.Data.CellRange r;
r = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 3, 3);
gcSpreadSheet1.Sheets[0].AddSpanCell(r, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells);
gcSpreadSheet1.Sheets[0].RowHeader.ColumnCount = 2;
gcSpreadSheet1.Sheets[0].ColumnHeader.RowCount = 2;
GrapeCity.Windows.SpreadSheet.Data.CellRange r2;
r2 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 2, 2);
gcSpreadSheet1.Sheets[0].AddSpanCell(r2, GrapeCity.Windows.SpreadSheet.Data.SheetArea.RowHeader);
gcSpreadSheet1.Invalidate();

VB.NET	Copy Code
Dim r As GrapeCity.Windows.SpreadSheet.Data.CellRange r = New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 3, 3) GcSpreadSheet1.Sheets(0).AddSpanCell(r, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells) GcSpreadSheet1.Sheets(0).RowHeader.ColumnCount = 2 GcSpreadSheet1.Sheets(0).ColumnHeader.RowCount = 2 Dim r2 As GrapeCity.Windows.SpreadSheet.Data.CellRange r2 = New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 2, 2) GcSpreadSheet1.Sheets(0).AddSpanCell(r2, GrapeCity.Windows.SpreadSheet.Data.SheetArea.RowHeader) GcSpreadSheet1.Invalidate()

VB.NET

Copy Code

Dim r As GrapeCity.Windows.SpreadSheet.Data.CellRange
r = New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 3, 3)
GcSpreadSheet1.Sheets(0).AddSpanCell(r, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells)
GcSpreadSheet1.Sheets(0).RowHeader.ColumnCount = 2
GcSpreadSheet1.Sheets(0).ColumnHeader.RowCount = 2
Dim r2 As GrapeCity.Windows.SpreadSheet.Data.CellRange
r2 = New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 2, 2)
GcSpreadSheet1.Sheets(0).AddSpanCell(r2, GrapeCity.Windows.SpreadSheet.Data.SheetArea.RowHeader)
GcSpreadSheet1.Invalidate()