Visual Basic (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 _ ) |
Visual Basic (Usage) | Copy Code |
---|---|
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) |
C# | |
---|---|
public void ClearRange( int row, int column, int rowCount, int columnCount, bool dataOnly, ClipboardCopyOptions 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
This example clears the range.
C# | Copy Code |
---|---|
private void Form1_Load(object sender, EventArgs e) { fpSpread1.Sheets[0].Cells[0, 0].Text = "test"; fpSpread1.Sheets[0].Cells[0, 1].Text = "B"; fpSpread1.Sheets[0].Cells[0, 2].Text = "C"; fpSpread1.Sheets[0].Columns[1].Visible = false; } private void button1_Click(object sender, EventArgs e) { fpSpread1.Sheets[0].ClearRange(0, 0, 5, 5, true, FarPoint.Win.Spread.ClipboardCopyOptions.Values); //fpSpread1.Sheets[0].ClearRange(0, 0, 5, 5, true); } |
Visual Basic | Copy Code |
---|---|
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load FpSpread1.Sheets(0).Cells(0, 0).Text = "test" FpSpread1.Sheets(0).Cells(0, 1).Text = "B" FpSpread1.Sheets(0).Cells(0, 2).Text = "C" FpSpread1.Sheets(0).Columns(1).Visible = False End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click FpSpread1.Sheets(0).ClearRange(0, 0, 5, 5, True, FarPoint.Win.Spread.ClipboardCopyOptions.Values) 'FpSpread1.Sheets(0).ClearRange(0, 0, 5, 5, True) End Sub |
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8