Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FilterColumnDefinitionCollection Class / Remove Method
Filter column definition to remove from the collection
Example


In This Topic
    Remove Method (FilterColumnDefinitionCollection)
    In This Topic
    Removes the specified filter column definition from the collection.
    Syntax
    'Declaration
     
    Public Overridable Sub Remove( _
       ByVal fcd As FilterColumnDefinition _
    ) 
    'Usage
     
    Dim instance As FilterColumnDefinitionCollection
    Dim fcd As FilterColumnDefinition
     
    instance.Remove(fcd)
    public virtual void Remove( 
       FilterColumnDefinition fcd
    )

    Parameters

    fcd
    Filter column definition to remove from the collection
    Example
    This example removes the specified filtered column from the collection.
    FarPoint.Web.Spread.NamedStyle instyle = new FarPoint.Web.Spread.NamedStyle(); 
    FarPoint.Web.Spread.NamedStyle outstyle = new FarPoint.Web.Spread.NamedStyle(); 
    instyle.BackColor = Color.Yellow; 
    outstyle.BackColor = Color.Aquamarine; 
    FarPoint.Web.Spread.FilterColumnDefinitionCollection fcdc = new FarPoint.Web.Spread.FilterColumnDefinitionCollection(); 
    FarPoint.Web.Spread.FilterColumnDefinition fcd = new FarPoint.Web.Spread.FilterColumnDefinition(1, FarPoint.Web.Spread.FilterListBehavior.SortByMostOccurrences
    | FarPoint.Web.Spread.FilterListBehavior.Default); 
    FarPoint.Web.Spread.FilterColumnDefinition fcd1 = new FarPoint.Web.Spread.FilterColumnDefinition(2, FarPoint.Web.Spread.FilterListBehavior.Default);
    
    FarPoint.Web.Spread.FilterColumnDefinition fcd2 = new FarPoint.Web.Spread.FilterColumnDefinition(3); 
    fcdc.Insert(0, fcd); 
    fcdc.Insert(1, fcd1); 
    fcdc.Insert(2, fcd2); 
    FarPoint.Web.Spread.StyleRowFilter sf = new FarPoint.Web.Spread.StyleRowFilter(FpSpread1.ActiveSheetView, instyle, outstyle);
    
    foreach (FarPoint.Web.Spread.FilterColumnDefinition x in fcdc) 
    { 
     sf.AddColumn(x); 
    }
    fcdc.Remove(fcd2);
    
    Dim instyle As New FarPoint.Web.Spread.NamedStyle
    Dim outstyle As New FarPoint.Web.Spread.NamedStyle
    instyle.BackColor = Color.Yellow
    outstyle.BackColor = Color.Aquamarine
    Dim fcdc As New FarPoint.Web.Spread.FilterColumnDefinitionCollection
    Dim fcd As New FarPoint.Web.Spread.FilterColumnDefinition(1, FarPoint.Web.Spread.FilterListBehavior.SortByMostOccurrences
    Or FarPoint.Web.Spread.FilterListBehavior.Default)
    Dim fcd1 As New FarPoint.Web.Spread.FilterColumnDefinition(2, FarPoint.Web.Spread.FilterListBehavior.Default)
    Dim fcd2 As New FarPoint.Web.Spread.FilterColumnDefinition(3)
    fcdc.Insert(0, fcd)
    fcdc.Insert(1, fcd1)
    fcdc.Insert(2, fcd2)
    Dim sf As New FarPoint.Web.Spread.StyleRowFilter(FpSpread1.ActiveSheetView, instyle, outstyle)
    Dim x As FarPoint.Web.Spread.FilterColumnDefinition
    For Each x In fcdc
          sf.AddColumn(x)
    Next
    fcdc.Remove(fcd2)
    
    See Also