Skip to main content

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

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