AddSelection Method (BaseSheetSelectionModel)

In This Topic

Adds a cell or cells to the selection.

Syntax

Visual Basic
C#

'Declaration
 
Public Overridable Sub AddSelection( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer _
)

'Usage
 
Dim instance As BaseSheetSelectionModel
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
 
instance.AddSelection(row, column, rowCount, columnCount)

public virtual void AddSelection( 
   int row,
   int column,
   int rowCount,
   int columnCount
)

Parameters

row: Row index of first cell to add
column: Column index of the first cell to add
rowCount: Number of rows to add
columnCount: Number of columns to add

Example

This example adds a selection and then extends it.

private void menuItem1_Click(object sender, System.EventArgs e)
{
FarPoint.Win.Spread.Model.BaseSheetSelectionModel selModel;
selModel = (FarPoint.Win.Spread.Model.BaseSheetSelectionModel)fpSpread1.ActiveSheet.Models.Selection;
selModel.AddSelection(0,0,3,4);
}

private void menuItem2_Click(object sender, System.EventArgs e)
{
FarPoint.Win.Spread.Model.BaseSheetSelectionModel selModel;
selModel = (FarPoint.Win.Spread.Model.BaseSheetSelectionModel)fpSpread1.ActiveSheet.Models.Selection;
selModel.ExtendSelection(4, 5);
}

Visual Basic

Private Sub MenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem1.Click
Dim selModel As FarPoint.Win.Spread.Model.BaseSheetSelectionModel
selModel = fpSpread1.ActiveSheet.Models.Selection
selModel.AddSelection(0, 0, 3, 4)
End Sub

Private Sub MenuItem2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem2.Click
Dim selModel As FarPoint.Win.Spread.Model.BaseSheetSelectionModel
selModel = fpSpread1.ActiveSheet.Models.Selection
selModel.ExtendSelection(4, 5)
End Sub

Reference

BaseSheetSelectionModel Class
BaseSheetSelectionModel Members

Product Support Forum | Print this page