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.