Spread Windows Forms 11.0 Product Documentation
FrozenRowCount Property
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : FrozenRowCount Property
Gets or sets the number of non-scrolling rows on the leading edge of this sheet.
Syntax
'Declaration
 
Public Property FrozenRowCount As Integer
'Usage
 
Dim instance As SheetView
Dim value As Integer
 
instance.FrozenRowCount = value
 
value = instance.FrozenRowCount
public int FrozenRowCount {get; set;}

Property Value

Integer number of frozen rows
Exceptions
ExceptionDescription
Specified value is out of range; must be greater than or equal to zero
Remarks

This property freezes the first m rows between the headers and the first scrollable viewport similar to how the frozen trailing property (FrozenTrailingRowCount) freezes the last n rows between the last scrollable viewport and the scroll bars.

Example
This example sets the number of rows that cannot be scrolled to ten.
fpSpread1.ActiveSheet.FrozenColumnCount = 10;
fpSpread1.ActiveSheet.FrozenRowCount = 10;
FpSpread1.ActiveSheet.FrozenColumnCount = 10
FpSpread1.ActiveSheet.FrozenRowCount = 10
See Also

Reference

SheetView Class
SheetView Members

User-Task Documentation

Setting Fixed (Frozen) Rows or Columns