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


In This Topic
    AutoSortFrozenRows Property
    In This Topic
    Gets or sets a value that indicates whether frozen rows are sorted.
    Syntax
    'Declaration
 
Public Property AutoSortFrozenRows As Boolean
    'Usage
 
Dim instance As SheetView
Dim value As Boolean
 
instance.AutoSortFrozenRows = value
 
value = instance.AutoSortFrozenRows
    public bool AutoSortFrozenRows {get; set;}
    Example
    This example sets the AutoSortFrozenRows property. 
    FpSpread1.Sheets[0].AutoSortFrozenRows = true;
FpSpread1.Sheets[0].AutoSortFrozenTrailingRows = true;
FpSpread1.Sheets[0].SetColumnAllowAutoSort(0,true);
FpSpread1.Sheets[0].FrozenTrailingRowCount = 1;
FpSpread1.Sheets[0].FrozenRowCount = 1;
FpSpread1.Sheets[0].Rows.Count = 5;
    FpSpread1.Sheets(0).AutoSortFrozenTrailingRows = True
FpSpread1.Sheets(0).AutoSortFrozenRows = True
FpSpread1.Sheets(0).SetColumnAllowAutoSort(0, True)
FpSpread1.Sheets(0).FrozenTrailingRowCount = 1
FpSpread1.Sheets(0).FrozenRowCount = 1
FpSpread1.Sheets(0).Rows.Count = 5
    See Also

    Reference

    SheetView Class
    SheetView Members

     

     

    Copyright © 2003-2020 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page