Selection Class
A class for managing the selection of cells or ranges in a spreadsheet.
Inheritance
Object
Documents.Spreadsheet.Selection
Namespace: Radzen.Documents.Spreadsheet
Assembly: Radzen.Blazor.dll
Syntax
public class SelectionConstructors
Selectionlink
A class for managing the selection of cells or ranges in a spreadsheet.
Declaration
public Selection(Documents.Spreadsheet.Worksheet sheet)Parameters
| Type | Name | Description |
|---|---|---|
| Documents.Spreadsheet.Worksheet | sheet |
Properties
Celllink
Gets or sets the currently active cell reference.
Declaration
public Documents.Spreadsheet.CellRef Cell { get; }Property Value
| Type | Description |
|---|---|
| Documents.Spreadsheet.CellRef | Gets or sets the currently active cell reference. |
Rangelink
Gets or sets the range of cells that are currently selected.
Declaration
public Documents.Spreadsheet.RangeRef Range { get; }Property Value
| Type | Description |
|---|---|
| Documents.Spreadsheet.RangeRef | Gets or sets the range of cells that are currently selected. |
Methods
Clearlink
Clears the current selection, resetting both the active cell and range to invalid states.
Declaration
public void Clear()Mergelink
Merges the current selection with another cell address, expanding the selection range to include both addresses.
Declaration
public void Merge(Documents.Spreadsheet.CellRef address)Parameters
| Type | Name | Description |
|---|---|---|
| Documents.Spreadsheet.CellRef | address |
Selectlink
Selects a column in the spreadsheet, updating the active cell and range to cover the entire column.
Declaration
public void Select(Documents.Spreadsheet.ColumnRef column)Parameters
| Type | Name | Description |
|---|---|---|
| Documents.Spreadsheet.ColumnRef | column |
Selectlink
Selects a column in the spreadsheet, updating the active cell and range to cover the entire column.
Declaration
public void Select(Documents.Spreadsheet.RowRef row)Parameters
| Type | Name | Description |
|---|---|---|
| Documents.Spreadsheet.RowRef | row |
Selectlink
Selects a column in the spreadsheet, updating the active cell and range to cover the entire column.
Declaration
public Documents.Spreadsheet.CellRef Select(Documents.Spreadsheet.CellRef address)Parameters
| Type | Name | Description |
|---|---|---|
| Documents.Spreadsheet.CellRef | address |
Returns
| Type | Description |
|---|---|
| Documents.Spreadsheet.CellRef |
Selectlink
Selects a column in the spreadsheet, updating the active cell and range to cover the entire column.
Declaration
public void Select(Documents.Spreadsheet.CellRef cell, Documents.Spreadsheet.RangeRef range)Parameters
| Type | Name | Description |
|---|---|---|
| Documents.Spreadsheet.CellRef | cell | |
| Documents.Spreadsheet.RangeRef | range |
Selectlink
Selects a column in the spreadsheet, updating the active cell and range to cover the entire column.
Declaration
public void Select(Documents.Spreadsheet.RangeRef range)Parameters
| Type | Name | Description |
|---|---|---|
| Documents.Spreadsheet.RangeRef | range |
Events
Changedlink
Event that is triggered when the selection changes.
Declaration
public event Action ChangedRangeFinalizedlink
Event that is triggered when the user finalizes a selection — i.e. releases the pointer after a click or drag on the sheet. Subscribers (such as the range picker) use this to commit a picked range.
Declaration
public event Action RangeFinalized