Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / RemoveSpanCell Method
Row index of anchor cell for span (at which spanned cells started)
Column index of anchor cell for span (at which spanned cells started)
Example


In This Topic
    RemoveSpanCell Method
    In This Topic
    Removes the span that contains a specified anchor cell from a range of cells on this sheet.
    Syntax
    'Declaration
     
    Public Sub RemoveSpanCell( _
       ByVal row As Integer, _
       ByVal column As Integer _
    ) 
    'Usage
     
    Dim instance As SheetView
    Dim row As Integer
    Dim column As Integer
     
    instance.RemoveSpanCell(row, column)
    public void RemoveSpanCell( 
       int row,
       int column
    )

    Parameters

    row
    Row index of anchor cell for span (at which spanned cells started)
    column
    Column index of anchor cell for span (at which spanned cells started)
    Example
    This example removes a selection and a span cell from the sheet.
    DialogResult dlg;
    fpSpread1.ActiveSheet.AddSpanCell(0, 0, 2, 2);
    fpSpread1.ActiveSheet.AddSelection(2, 0, 2, 2);
    dlg = MessageBox.Show("Do you want to remove the selection and span cell?", "RemoveSelection/SpanCell", MessageBoxButtons.YesNo);
    if (dlg == DialogResult.Yes)
    {
        fpSpread1.ActiveSheet.RemoveSelection(2, 0, 2, 2);
        fpSpread1.ActiveSheet.RemoveSpanCell(0, 0);
    }
    Dim dlg As DialogResult
    FpSpread1.ActiveSheet.AddSpanCell(0, 0, 2, 2)
    FpSpread1.ActiveSheet.AddSelection(2, 0, 2, 2)
    dlg = MessageBox.Show("Do you want to remove the selection and span cell?", "RemoveSelection/SpanCell", MessageBoxButtons.YesNo)
    If dlg = DialogResult.Yes Then
        FpSpread1.ActiveSheet.RemoveSelection(2, 0, 2, 2)
        FpSpread1.ActiveSheet.RemoveSpanCell(0, 0)
    End If
    See Also