Spread WinForms 15
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / ClearRange Method / ClearRange(Int32,Int32,Int32,Int32,Boolean) 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


In This Topic
ClearRange(Int32,Int32,Int32,Int32,Boolean) 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 _
)
 
'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)

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
See Also

Reference

SheetView Class
SheetView Members
Overload List

 

 

Copyright © 2021 GrapeCity, Inc. All rights reserved.

Product Support Forum | Print this page