Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / ClearRange 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
Example


In This Topic
    ClearRange Method
    In This Topic
    Removes all of the data, formatting, formulas, and notes from a range of cells on this sheet.
    Syntax
    'Declaration
     
    Public Sub ClearRange( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal rowCount As Integer, _
       ByVal columnCount As Integer, _
       ByVal dataOnly As Boolean _
    ) 
    '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
     
    instance.ClearRange(row, column, rowCount, columnCount, dataOnly)
    public void ClearRange( 
       int row,
       int column,
       int rowCount,
       int columnCount,
       bool dataOnly
    )

    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
    Remarks
    If you set the dataOnly parameter to true, the method clears the formulas, the cell notes, and the text in the cells in that range; in other words, it clears all the information that is in the data model for those cells.
    Example
    This example uses the ClearRange method.
    FpSpread1.Sheets[0].ClearRange(0, 0, 2, 2, false);
    FpSpread1.Sheets(0).ClearRange(0, 0, 2, 2, False)
    See Also