Spread WPF 15
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

    Reference

    Worksheet Class
    Worksheet Members
    Overload List

     

     

    Copyright © 2021 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page