TdxSpreadSheetTableView.FreezeColumns(string) Method

Immobilizes one or more sequential worksheet columns at the left border of the Spreadsheet control’s content area.

Declaration

procedure FreezeColumns(const AColumn: string); overload;

Parameters

Name	Type
AColumn	string

Remarks

The first overloaded procedure variant accepts the index of the last column within the vertical frozen pane at the control’s left border.

The second procedure variant works identically to the first variant, but accepts a reference (as a string in the A1 format) to the last frozen column instead of the column’s index.

The both FreezeColumns procedure variants are particularly useful if you need to customize the row header in a spreadsheet document. You can also set the Options.Headers property to bFalse to hide the standard worksheet headers:

Note

Call the FreezePanes procedure if you need to freeze a number of both rows and columns at the top and left control’s borders, since a FreezeRows procedure call unfreezes frozen columns, and a FreezeColumns call unfreezes frozen rows, respectively.