The Selection property specifies the range of cells selected in a worksheet that is currently active (B3:F9, in the image below). The SelectedCell property specifies a single cell located in the active worksheet where data is inserted when an end-user types (E7, in the image below). In other words, the selected cell is an active cell that can be also obtained via the ActiveCell property. Selection can be a single cell or range of cells, while SelectedCell is always a single cell inside the current selection.
The following code sets selection and active cell as shown in the image above.
| C# |
using DevExpress.Spreadsheet;
IWorkbook workbook = spreadsheetControl1.Document;
Worksheet activeSheet = workbook.Worksheets.ActiveWorksheet;
spreadsheetControl1.Selection = activeSheet.Range["B3:F9"];
spreadsheetControl1.SelectedCell = activeSheet.Cells["E7"];
|
| VB |
Imports DevExpress.Spreadsheet
Dim workbook As IWorkbook = spreadsheetControl1.Document
Dim activeSheet As Worksheet = workbook.Worksheets.ActiveWorksheet
spreadsheetControl1.Selection = activeSheet.Range("B3:F9")
spreadsheetControl1.SelectedCell = activeSheet.Cells("E7")
|