FarPoint.Win.Spread.SheetView.ClearRange

ClearRange Method

ClearRange(int, int, int, int, bool)

Removes all of the data, formatting, formulas, and notes from a range of cells on this sheet.

Declaration

public void ClearRange(int row, int column, int rowCount, int columnCount, bool dataOnly)

Public Sub ClearRange(row As Integer, column As Integer, rowCount As Integer, columnCount As Integer, dataOnly As Boolean)

Parameters

Type	Name	Description
int	row	Row index of first cell in range
int	column	Column index of first cell in range
int	rowCount	Number of rows in range
int	columnCount	Number of columns in range
bool	dataOnly	Whether to remove only data

ClearRange(int, int, int, int, bool, ClipboardCopyOptions)

Removes all of the data, formatting, formulas, and notes from a range of cells on this sheet.

Declaration

public void ClearRange(int row, int column, int rowCount, int columnCount, bool dataOnly, ClipboardCopyOptions copyOptions)

Public Sub ClearRange(row As Integer, column As Integer, rowCount As Integer, columnCount As Integer, dataOnly As Boolean, copyOptions As ClipboardCopyOptions)

Parameters

Type	Name	Description
int	row	Row index of first cell in range
int	column	Column index of first cell in range
int	rowCount	Number of rows in range
int	columnCount	Number of columns in range
bool	dataOnly	Whether to remove only data
ClipboardCopyOptions	copyOptions	ClipboardCopyOptions

ClearRange Method
ClearRange(int, int, int, int, bool)
Declaration
Parameters
ClearRange(int, int, int, int, bool, ClipboardCopyOptions)
Declaration
Parameters