Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / FrozenRowCount Property
Example


In This Topic
    FrozenRowCount Property
    In This Topic
    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