Skip to main content

TdxSpreadSheetTableView.FrozenColumn Property

Specifies an index of the frozen column adjacent to a frozen pane separator.

Declaration

property FrozenColumn: Integer read; write; default -1;

Property Value

Type
Integer

Remarks

To create a vertical frozen pane within the current Table View worksheet, assign an index of the rightmost column in the pane you need to create, to this property. All columns with specified and lower index values become a single unscrollable vertical pane at the left edge of the Table View worksheet, separated from its scrollable part by a vertical line.

The FrozenColumn and FrozenRow properties are particularly useful for creating custom row and column worksheet headers.

The following code example creates a vertical frozen pane from the two leftmost columns in the Table View worksheet (i.e. columns with 0 and 1 indexes).

dxSpreadSheet1.ActiveSheetAsTable.FrozenColumn := 1;

The result of this code execution is displayed in the image below.

To unfreeze the created vertical pane, you can either set the FrozenColumn property to -1, or call the UnfreezePanes procedure.

The default value of the FrozenColumn property is -1.

See Also