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


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

    Property Value

    The number of nonscrolling columns 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 FrozenColumnCount 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