All docs
V20.1
20.2 (EAP/Beta)
20.1
19.2
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.

SpreadsheetControl.SetSelectedRanges(IList<CellRange>) Method

Selects multiple ranges in the active worksheet.

Namespace: DevExpress.Xpf.Spreadsheet

Assembly: DevExpress.Xpf.Spreadsheet.v20.1.dll

Declaration

public bool SetSelectedRanges(
    IList<CellRange> ranges
)
Public Function SetSelectedRanges(
    ranges As IList(Of CellRange)
) As Boolean

Parameters

Name Type Description
ranges IList<CellRange>

A list of the CellRange objects.

Returns

Type Description
Boolean

true if cell ranges are selected successfully; otherwise false. If you pass null (Nothing in Visual Basic), or an empty list, or a list that contains at least one cell range located in a worksheet other than the active worksheet, the method returns false.

Remarks

The image below illustrates the use of the SpreadsheetControl.SetSelectedRanges method to select multiple non-adjacent ranges. The SpreadsheetControl.SelectedCell sets the selected (active) cell that gets user input. Note that if a cell outside the selected ranges was assigned to the SelectedCell property, selected ranges would be reset so that the active cell becomes the only selected range in the worksheet.

SetSelectedRanges

static void SetSelectedRanges(SpreadsheetControl control)
{
    control.BeginUpdate();
    Worksheet worksheet = control.ActiveWorksheet;

    CellRange r1 = worksheet.Range["A1:B10"];
    CellRange r2 = worksheet.Range["E12"];
    CellRange r3 = worksheet.Range["D4:E7"];
    List<CellRange> rlist = new List<CellRange>() { r1, r2, r3 };
    control.SetSelectedRanges(rlist);

    control.SelectedCell = worksheet.Cells["E5"];

    control.EndUpdate();
}

End-users can select multiple ranges if the SpreadsheetSelectionOptions.AllowMultiSelection option is true. This option is accessible via the SpreadsheetControl.Options.Behavior.AllowMultiSelection notation.

NOTE

To select ranges in a specific worksheet (which may or may not be active) of the document loaded in the SpreadsheetControl, use the Worksheet.SetSelectedRanges method of the worksheet object.

Implements

DevExpress.XtraSpreadsheet.ISpreadsheetControl.SetSelectedRanges(IList<CellRange>)
See Also