Spread Windows Forms 17
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / ClearRange Method / ClearRange(Int32,Int32,Int32,Int32,Boolean,ClipboardCopyOptions) Method
Row index of first cell in range
Column index of first cell in range
Number of rows in range
Number of columns in range
Whether to remove only data
ClipboardCopyOptions


In This Topic
    ClearRange(Int32,Int32,Int32,Int32,Boolean,ClipboardCopyOptions) Method
    In This Topic
    Removes all of the data, formatting, formulas, and notes from a range of cells on this sheet.
    Syntax
    'Declaration
     
    
    Public Overloads Sub ClearRange( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal rowCount As Integer, _
       ByVal columnCount As Integer, _
       ByVal dataOnly As Boolean, _
       ByVal copyOptions As ClipboardCopyOptions _
    ) 
    'Usage
     
    
    Dim instance As SheetView
    Dim row As Integer
    Dim column As Integer
    Dim rowCount As Integer
    Dim columnCount As Integer
    Dim dataOnly As Boolean
    Dim copyOptions As ClipboardCopyOptions
     
    instance.ClearRange(row, column, rowCount, columnCount, dataOnly, copyOptions)

    Parameters

    row
    Row index of first cell in range
    column
    Column index of first cell in range
    rowCount
    Number of rows in range
    columnCount
    Number of columns in range
    dataOnly
    Whether to remove only data
    copyOptions
    ClipboardCopyOptions
    See Also