New to Telerik Document Processing? Start a free 30-day trial

Rows

Class

Manages the collection of rows in a worksheet, providing access to row properties, heights, and operations like insert and remove.

Definition

Namespace:Telerik.Windows.Documents.Spreadsheet.Model

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

public class Rows : RowsColumnsBase

Inheritance: objectWorksheetEntityBaseRowsColumnsBaseRows

Inherited Members RowsColumnsBase.Insert(int)RowsColumnsBase.Insert(int, int)RowsColumnsBase.Remove(int)RowsColumnsBase.Remove(int, int)RowsColumnsBase.CellsWorksheetEntityBase.Worksheet...

Properties

Count

int

Gets the total number of rows in the worksheet.

public override int Count { get; }

Property Value:

The row / column count.

Overrides: RowsColumnsBase.Count

this[CellIndex]

RowSelection

Gets a RowSelection for the row containing the specified cell index.

public RowSelection this[CellIndex cellIndex] { get; }

Parameters:cellIndexCellIndexProperty Value:

The row selection.

this[CellRange]

RowSelection

Gets a RowSelection for the rows intersecting the specified cell range.

public RowSelection this[CellRange cellRange] { get; }

Parameters:cellRangeCellRangeProperty Value:

The row selection.

this[IEnumerable<CellRange>]

RowSelection

Gets a RowSelection for the rows intersecting the specified collection of cell ranges.

public RowSelection this[IEnumerable<CellRange> cellRanges] { get; }

Parameters:cellRangesIEnumerable<CellRange>Property Value:

The row selection.

this[int, int]

RowSelection

Gets a RowSelection for the continuous range of rows between the specified start and end indices.

public RowSelection this[int fromIndex, int toIndex] { get; }

Parameters:fromIndexinttoIndexintProperty Value:

The row selection.

this[int]

RowSelection

Gets a RowSelection for the row at the specified index.

public RowSelection this[int index] { get; }

Parameters:indexintProperty Value:

The row selection.

Methods

CanInsert(int, int)

Checks whether the specified number of rows can be inserted at the given index without exceeding worksheet limits.

public override bool CanInsert(int index, int itemCount)

Parameters:indexint

The index.

itemCountint

The item count.

Returns:

bool

The value indicating whether this instance can be inserted at the specified index

Overrides: RowsColumnsBase.CanInsert(int, int)

GetDefaultHeight()

Gets the default height applied to rows without custom height settings.

public RowHeight GetDefaultHeight()

Returns:

RowHeight

The row height

GetRowSelection(CellIndex)

Creates a row selection for the row containing the specified cell index.

public RowSelection GetRowSelection(CellIndex cellIndex)

Parameters:cellIndexCellIndex

Index of the cell.

Returns:

RowSelection

The row selection

GetRowSelection(CellRange)

Creates a row selection for the rows intersecting the specified cell range.

public RowSelection GetRowSelection(CellRange cellRange)

Parameters:cellRangeCellRange

The cell range.

Returns:

RowSelection

The row selection

GetRowSelection(IEnumerable<CellRange>)

Creates a row selection for the rows intersecting the specified collection of cell ranges.

public RowSelection GetRowSelection(IEnumerable<CellRange> cellRanges)

Parameters:cellRangesIEnumerable<CellRange>

The cell ranges.

Returns:

RowSelection

The row selection

GetRowSelection(int, int)

Creates a row selection for the continuous range of rows between the specified start and end indices.

public RowSelection GetRowSelection(int fromIndex, int toIndex)

Parameters:fromIndexint

From index.

toIndexint

To index.

Returns:

RowSelection

The row selection

GetRowSelection(int)

Creates a row selection for the single row at the specified index.

public RowSelection GetRowSelection(int index)

Parameters:indexint

The index.

Returns:

RowSelection

The row selection

InsertOverride(int, int)

Executes the row insertion command at the specified index, shifting existing rows downward.

protected override bool InsertOverride(int index, int itemCount)

Parameters:indexint

The index.

itemCountint

The item count.

Returns:

bool

Overrides: RowsColumnsBase.InsertOverride(int, int)

RemoveOverride(int, int)

Executes the row removal command at the specified index, shifting remaining rows upward.

protected override void RemoveOverride(int index, int itemCount)

Parameters:indexint

The index.

itemCountint

The item count.

Overrides: RowsColumnsBase.RemoveOverride(int, int)

SetDefaultHeight(RowHeight)

Sets the default height for all rows that do not have a custom height assigned.

public void SetDefaultHeight(RowHeight height)

Parameters:heightRowHeight

The height.

Events

RowsHeightsChanged

EventHandler<RowColumnPropertyChangedEventArgs>

Raised when row heights are modified, providing the range of affected rows.

public event EventHandler<RowColumnPropertyChangedEventArgs> RowsHeightsChanged