Back to all docs
API Reference / Telerik.Windows.Documents.Spreadsheet.Model / RowSelection
New to Telerik Document Processing? Start a free 30-day trial

RowSelection

Class

Manages a selection of entire rows, providing access to row-specific properties like height, hidden state, and outline level for formatting and manipulation.

Definition

Namespace:Telerik.Windows.Documents.Spreadsheet.Model

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:
C#
public class RowSelection : RowColumnSelectionBase

Inheritance: objectSelectionBaseRowColumnSelectionBaseRowSelection

Inherited Members RowColumnSelectionBase.GetPropertyValue<T>(IPropertyDefinition<T>)RowColumnSelectionBase.Group()RowColumnSelectionBase.Ungroup()RowColumnSelectionBase.SetOutlineLevel(int)RowColumnSelectionBase.ClearOutlineLevel()SelectionBase.BeginUpdate()SelectionBase.EndUpdate()SelectionBase.ExecuteForEachRangeInsideBeginEndUpdate(Action<CellRange>)SelectionBase.ExecuteForEachRangeInsideBeginEndUpdate(IEnumerable<CellRange>, Action<CellRange>, Predicate<CellRange>)SelectionBase.ExecuteForEachRange(Action<CellRange>)SelectionBase.ExecuteForEachRange(IEnumerable<CellRange>, Action<CellRange>, Predicate<CellRange>)SelectionBase.GetPropertyValue<T>(Func<CellRange, RangePropertyValue<T>>, IEnumerable<CellRange>, T)SelectionBase.GetTopLeftCellIndex()SelectionBase.Clear(ClearType)SelectionBase.GetFormat()SelectionBase.SetFormat(CellValueFormat)SelectionBase.ClearFormat()SelectionBase.GetStyleName()SelectionBase.SetStyleName(string)SelectionBase.ClearStyleName()SelectionBase.GetFill()SelectionBase.SetFill(IFill)SelectionBase.ClearFill()SelectionBase.GetFontFamily()SelectionBase.SetFontFamily(ThemableFontFamily)SelectionBase.ClearFontFamily()SelectionBase.GetFontSize()SelectionBase.SetFontSize(double)SelectionBase.ClearFontSize()SelectionBase.GetIsBold()SelectionBase.SetIsBold(bool)SelectionBase.ClearIsBold()SelectionBase.GetIsItalic()SelectionBase.SetIsItalic(bool)SelectionBase.ClearIsItalic()SelectionBase.GetIsStrikethrough()SelectionBase.SetIsStrikethrough(bool)SelectionBase.ClearIsStrikethrough()SelectionBase.GetVerticalTextAlignment()SelectionBase.SetVerticalTextAlignment(VerticalTextAlignment)SelectionBase.ClearVerticalTextAlignment()SelectionBase.GetUnderline()SelectionBase.SetUnderline(UnderlineType)SelectionBase.ClearUnderline()SelectionBase.GetForeColor()SelectionBase.SetForeColor(ThemableColor)SelectionBase.ClearForeColor()SelectionBase.GetHorizontalAlignment()SelectionBase.SetHorizontalAlignment(RadHorizontalAlignment)SelectionBase.ClearHorizontalAlignment()SelectionBase.GetVerticalAlignment()SelectionBase.SetVerticalAlignment(RadVerticalAlignment)SelectionBase.ClearVerticalAlignment()SelectionBase.GetIndent()SelectionBase.SetIndent(int)SelectionBase.ClearIndent()SelectionBase.IncreaseIndent()SelectionBase.DecreaseIndent()SelectionBase.GetIsWrapped()SelectionBase.SetIsWrapped(bool)SelectionBase.ClearIsWrapped()SelectionBase.GetTextRotation()SelectionBase.SetTextRotation(int)SelectionBase.ClearTextRotation()SelectionBase.GetBorders()SelectionBase.ClearBorders()SelectionBase.GetIsLocked()SelectionBase.SetIsLocked(bool)SelectionBase.ClearIsLocked()SelectionBase.CellRangesSelectionBase.Worksheet...

Methods

AutoFitHeight()

Adjusts the height of selected rows to automatically fit their content.

C#
public void AutoFitHeight()

ClearHeight()

Removes custom height settings from the selected rows, reverting them to the default height.

C#
public void ClearHeight()

ClearHidden()

Removes the hidden state from the selected rows, making them visible.

C#
public void ClearHidden()

GetFromToIndexFromRange(CellRange, out int, out int)

Extracts the starting and ending row indices from the specified cell range.

C#
protected override void GetFromToIndexFromRange(CellRange cellRange, out int fromIndex, out int toIndex)
Parameters:cellRangeCellRange

The cell range.

fromIndexint

From index.

toIndexint

To index.

Overrides: RowColumnSelectionBase.GetFromToIndexFromRange(CellRange, out int, out int)

GetHeight()

Gets the height value for the selected rows, or an indeterminate state if heights differ across the selection.

C#
public RangePropertyValue<RowHeight> GetHeight()
Returns:

RangePropertyValue<RowHeight>

The height for the selection.

GetHidden()

Gets whether the selected rows are hidden, or an indeterminate state if visibility differs across the selection.

C#
public RangePropertyValue<bool> GetHidden()
Returns:

RangePropertyValue<bool>

The value of the hidden property

GetOutlineLevel()

Gets the outline level of the selected rows, indicating their grouping depth for collapse and expand.

C#
public override RangePropertyValue<int> GetOutlineLevel()
Returns:

RangePropertyValue<int>

The outline level.

Overrides: RowColumnSelectionBase.GetOutlineLevel()

Insert()

Inserts new rows at the positions of the selected rows, shifting existing rows downward.

C#
public bool Insert()
Returns:

bool

The value indicating whether the insert was successful.

Remove()

Deletes the selected rows from the worksheet, shifting remaining rows upward.

C#
public void Remove()

SetBorders(CellBorders)

Applies border styling to all cells within the selected rows.

C#
public override void SetBorders(CellBorders value)
Parameters:valueCellBorders

The value.

Overrides: SelectionBase.SetBorders(CellBorders)

SetHeight(RowHeight)

Applies the specified height to all rows in the selection.

C#
public void SetHeight(RowHeight value)
Parameters:valueRowHeight

The value.

SetHidden(bool)

Shows or hides the selected rows in the worksheet.

C#
public void SetHidden(bool value)
Parameters:valuebool

The value indicating whether the selected rows are hidden.

In this article
DefinitionMethodsAutoFitHeight()ClearHeight()ClearHidden()GetFromToIndexFromRange(CellRange, out int, out int)GetHeight()GetHidden()GetOutlineLevel()Insert()Remove()SetBorders(CellBorders)SetHeight(RowHeight)SetHidden(bool)
Not finding the help you need?
Contact Support