RowsFrozen Property
Applies To
fpSpread control
Description
Sets or returns the number of nonscrolling rows.
Syntax
long CSpreadSheet::GetRowsFrozen( );
void CSpreadSheet::SetRowsFrozen(long value);
[form.]fpSpread.RowsFrozen[ = value&]
Remarks
The default value for the RowsFrozen property is 0, which means that only the column header is frozen.
The RowsFrozen property specifies which rows in the sheet do not scroll, in essence creating additional rows of column headers. The frozen rows are always the top n rows, where n is the value of this property.
Notes:
|
You cannot freeze rows when the fpSpread control is in virtual mode.
This setting is applied to the current sheet setting unless you first set the Sheet property to specify the sheet for which you are setting the property.
To specify nonscrolling columns, set the ColsFrozen property.
Spread Designer
Choose the Sheet menu, then the Columns and Rows menu, select the Rows tab, and then choose or type a number in the Frozen Rows spin box in the Settings-All Rows group box in the Column and Row Settings dialog box.
Data Type
Long Integer
See Also
ColsFrozen, Sheet, TopRow properties
DLL Correspondence
SSGetFreeze, SSSetFreeze functions