Spread WPF 14
GrapeCity.Windows.SpreadSheet.Data Namespace / Worksheet Class / AddSpanCell Method / AddSpanCell(CellRange,SheetArea) Method
The cell range to span.
The sheet area.
Example


In This Topic
    AddSpanCell(CellRange,SheetArea) Method
    In This Topic
    Adds a span of cells in this sheet in the specified sheet area.
    Syntax
    'Declaration
     
    Public Overloads Sub AddSpanCell( _
       ByVal range As CellRange, _
       ByVal sheetArea As SheetArea _
    ) 
    'Usage
     
    Dim instance As Worksheet
    Dim range As CellRange
    Dim sheetArea As SheetArea
     
    instance.AddSpanCell(range, sheetArea)
    public void AddSpanCell( 
       CellRange range,
       SheetArea sheetArea
    )

    Parameters

    range
    The cell range to span.
    sheetArea
    The sheet area.
    Example
    This example uses the AddSpanCell method.
    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].AddSpanCell(1, 1, 3, 3);
    //gcSpreadSheet1.Sheets[0].AddSpanCell(4, 0, 2, 2, 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();
    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).AddSpanCell(1, 1, 3, 3)
    ' GcSpreadSheet1.Sheets(0).AddSpanCell(4, 0, 2, 2, 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()
    See Also