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.FreezePanes(Integer,Integer) Method

Freezes the specified numbers of rows and columns at the top and left edges of the Table View worksheet.

#Declaration

Delphi
procedure FreezePanes(const ARow: Integer; const AColumn: Integer); overload;

#Parameters

Name Type
ARow Integer
AColumn Integer

#Remarks

Call this procedure to exclude a number of rows and columns from scrolling, immobilizing them at the top and left borders of the Spreadsheet control. The ARow and AColumn parameters are used to specify indexes of the last row and column within the frozen panes, respectively.

The FreezePanes procedure is particularly useful if you need to customize the column and row headers within a spreadsheet document. To hide the standard headers displayed by the current Table View worksheet, set the Options.Headers property to bFalse:

Like the FreezePanes procedure, the FrozenColumn and FrozenRow properties allow you to immobilize any numbers of columns and rows simultaneously.

Note

To make the frozen columns and rows scrollable again, invoke the UnfreezePanes procedure.

See Also