CellArea.BottomRowIndex Property

Gets or sets the index of the bottom row of the cell area.

Namespace: DevExpress.Spreadsheet.Formulas

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public int BottomRowIndex { get; set; }

VB.NET

Public Property BottomRowIndex As Integer

Property Value

Type	Description
Int32	An integer that is the row index.

Remarks

The value is not validated after assignment. An incorrect value may result in an incorrect CellArea.ColumnCount or CellArea.RowCount property values. However, the references based on the cell area with incorrect settings may be valid due to internal normalization. The CellArea.ToString method, CellArea.TopLeft and CellArea.BottomRight properties always return correct, validated values.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the BottomRowIndex property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

winforms-spreadsheet-use-formula-engine/CS/FormulaEngineTest/MyVisitor.cs#L11

    expression.CellArea.TopRowIndex++;
    expression.CellArea.BottomRowIndex++;
}

VB.NET

winforms-spreadsheet-use-formula-engine/VB/FormulaEngineTest/MyVisitor.vb#L10

    expression.CellArea.TopRowIndex += 1
    expression.CellArea.BottomRowIndex += 1
End Sub