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.FreezeColumns(string) Method

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

#Declaration

Delphi
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.

See Also