TdxSpreadSheetTableView.GetNextRowWithNonEmptyCell(Integer,Integer,Boolean) Method

Returns the index of the nearest row object above or below the specified cell position.

Declaration

function GetNextRowWithNonEmptyCell(const ARow: Integer; const AColumn: Integer; const AGoForward: Boolean = True): Integer;

Name	Type	Description
ARow	Integer	The target row index.
AColumn	Integer	The target column index.
AGoForward	Boolean	Optional. Specifies the search direction: If `True` (default), the function searches the nearest non-empty row with a higher index than the `ARow` parameter value. If `False`, the function searches the nearest non-empty row with a lower index than the `ARow` parameter value.

Type	Description
Integer	The index of the nearest row that contains an initialized cell. If the search operation is successful, the function returns the index of the row with at least one initialized cell. If the search operation fails, the function returns `0` (if the `AGoForward` parameter value is `False`) or dxSpreadSheetMaxRowIndex (if `AGoForward` is `True`).