Skip to main content

TdxSpreadSheetTableView.FrozenRow Property

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

Declaration

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

Property Value

Type
Integer

Remarks

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

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

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

dxSpreadSheet1.ActiveSheetAsTable.FrozenRow := 1;

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

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

The default value of the FrozenRow property is -1.

See Also