Clear Method (IRangeSupport)

Removes all of the contents from the cells in the specified range of cells.

Syntax

Visual Basic
C#

'Declaration
 
Sub Clear( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer _
)

'Usage
 
Dim instance As IRangeSupport
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
 
instance.Clear(row, column, rowCount, columnCount)

void Clear( 
   int row,
   int column,
   int rowCount,
   int columnCount
)

Parameters

row: Row index of first row in selected range
column: Column index of first column in selected range
rowCount: Number of rows in selected range
columnCount: Number of columns in selected range

Example

private void Button1Click(object sender, System.EventArgs e)
{
    FarPoint.Web.Spread.Model.IRangeSupport irs;
    irs = (FarPoint.Web.Spread.Model.IRangeSupport)FpSpread1.ActiveSheetView.DataModel;
    irs.Clear(0, 0, 2, 2);
}

Visual Basic

Private Sub Button1Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim irs As FarPoint.Web.Spread.Model.IRangeSupport
    irs = FpSpread1.ActiveSheetView.DataModel
    irs.Clear(0, 0, 2, 2)
End Sub

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

IRangeSupport Interface
IRangeSupport Members