Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TdxSpreadSheetTableView.GetNextRowWithNonEmptyCell(Integer,Integer,Boolean) Method

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

#Declaration

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

#Parameters

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.

#Returns

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).
See Also