Spread 8.0 Documentation
RowsFrozen Property
Support Options
ActiveX Reference > ActiveX Properties > RowsFrozen Property

Glossary Item Box

RowsFrozen Property


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns the number of nonscrolling rows.

Syntax

C++

long CSpreadSheet::GetRowsFrozen( );
void CSpreadSheet::SetRowsFrozen(long value);

Visual Basic

[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:
  • Setting the RowsFrozen property to a value other than 0 may change the TopRow property setting.
  • Frozen rows print even if you specify a print range that does not include the frozen rows.

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

Freezing Columns and Rows

ColsFrozen, Sheet, TopRow properties

DLL Correspondence

SSGetFreeze, SSSetFreeze functions

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.