Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / Worksheet Class / FrozenRowCount Property
Example


In This Topic
    FrozenRowCount Property (Worksheet)
    In This Topic
    Gets or sets the number of nonscrolling rows on the leading edge of this sheet.
    Syntax
    'Declaration
     
    <DefaultValueAttribute(0)>
    Public Property FrozenRowCount As Integer
    'Usage
     
    Dim instance As Worksheet
    Dim value As Integer
     
    instance.FrozenRowCount = value
     
    value = instance.FrozenRowCount
    [DefaultValue(0)]
    public int FrozenRowCount {get; set;}

    Property Value

    The number of nonscrolling rows on the leading edge of this sheet.
    Exceptions
    ExceptionDescription
    Specified value is out of range; must be greater than or equal to zero.
    Example
    This example sets the FrozenRowCount property.
    gcSpreadSheet1.Sheets[0].RowCount = 10;
    gcSpreadSheet1.Sheets[0].ColumnCount = 8;
    gcSpreadSheet1.Sheets[0].FrozenColumnCount = 1;
    gcSpreadSheet1.Sheets[0].FrozenRowCount = 1;
    gcSpreadSheet1.Sheets[0].FrozenTrailingColumnCount = 1;
    gcSpreadSheet1.Sheets[0].FrozenTrailingRowCount = 1;
    gcSpreadSheet1.Invalidate();
    GcSpreadSheet1.Sheets(0).RowCount = 10
    GcSpreadSheet1.Sheets(0).ColumnCount = 8
    GcSpreadSheet1.Sheets(0).FrozenColumnCount = 1
    GcSpreadSheet1.Sheets(0).FrozenRowCount = 1
    GcSpreadSheet1.Sheets(0).FrozenTrailingColumnCount = 1
    GcSpreadSheet1.Sheets(0).FrozenTrailingRowCount = 1
    GcSpreadSheet1.Invalidate()
    See Also