Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / GetSpanCell Method
Row index of the specified cell
Column index of the specified cell
Example


In This Topic
    GetSpanCell Method
    In This Topic
    Gets the range of cells that are spanned at a specified cell on this sheet.
    Syntax
    'Declaration
     
    Public Overridable Function GetSpanCell( _
       ByVal row As Integer, _
       ByVal column As Integer _
    ) As CellRange
    'Usage
     
    Dim instance As SheetView
    Dim row As Integer
    Dim column As Integer
    Dim value As CellRange
     
    value = instance.GetSpanCell(row, column)
    public virtual CellRange GetSpanCell( 
       int row,
       int column
    )

    Parameters

    row
    Row index of the specified cell
    column
    Column index of the specified cell

    Return Value

    CellRange object containing the range of cells included in the span with the specified cell

    Example
    This example illustrates the use of this member by returning the range of the cell span.
    fpSpread1.ActiveSheet.AddSpanCell(0, 0, 2, 2);
    FarPoint.Win.Spread.Model.CellRange cr;
    cr = fpSpread1.ActiveSheet.GetSPanCell(0, 0);
    label1.Text = "The span covers cells " + cr.Row + ", " + cr.Column + ", " + cr.RowCount + ", " + cr.ColumnCount;
    Dim cr As FarPoint.Win.Spread.Model.CellRange
    FpSpread1.ActiveSheet.AddSpanCell(0, 0, 2, 2)
    cr = FpSpread1.ActiveSheet.GetSpanCell(0, 0)
    Label1.Text = "The span covers cells " & cr.Row & ", " & cr.Column & ", " & cr.RowCount & ", " & cr.ColumnCount
    See Also