Example
The following example clears any existing selections and selects the first five rows of the sheet.
C++
void CSelectedDlg::OnShowWindow(BOOL bShow, UINT nStatus)
{
CDialog::OnShowWindow(bShow, nStatus);
m_Spread.SetOperationMode(OperationModeExtended);
}
void CSelectedDlg::OnButton1()
{
int i;
m_Spread.ClearSelection();
// Select the first 5 rows
for( i=1;i<=5;i++ )
{
m_Spread.SetRow(i);
m_Spread.SetSelModeSelected(TRUE);
}
}
Visual Basic
Private Sub Form_Load()
' Set Operation Mode to extended selection
fpSpread1.OperationMode = OperationModeExtended
End Sub
Private Sub Command1_Click()
Dim i As Integer
'Clear selections
fpSpread1.ClearSelection
' Select the first 5 rows
For i = 1 To 5
fpSpread1.Row = i
fpSpread1.SelModeSelected = True
Next i
End Sub