Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SpreadCommandEventArgs Class / SortFrozenRows Property
Example


In This Topic
    SortFrozenRows Property
    In This Topic
    Gets or sets whether the frozen rows should be sorted when the sorting command occurs.
    Syntax
    'Declaration
     
    Public Property SortFrozenRows As Boolean
    'Usage
     
    Dim instance As SpreadCommandEventArgs
    Dim value As Boolean
     
    instance.SortFrozenRows = value
     
    value = instance.SortFrozenRows
    public bool SortFrozenRows {get; set;}
    Example
    This example sets the SortFrozenRows event argument.
    FpSpread1.Sheets[0].FrozenRowCount = 1;
    FpSpread1.Sheets[0].AllowSort = true;
    
    private void FpSpread1SortColumnCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
    {
       e.SortFrozenRows = true;
    }
    FpSpread1.Sheets(0).FrozenRowCount = 1
    FpSpread1.Sheets(0).AllowSort = True
    
    Protected Sub FpSpread1_SortColumnCommand(ByVal sender As Object, ByVal e As FarPoint.Web.Spread.SpreadCommandEventArgs) Handles FpSpread1.SortColumnCommand
            e.SortFrozenRows = True
    End Sub
    See Also