Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / NamedStyleCollection Class / Clear Method
Example


In This Topic
    Clear Method (NamedStyleCollection)
    In This Topic
    Removes all named styles from the collection.
    Syntax
    'Declaration
     
    Public Overridable Sub Clear() 
    'Usage
     
    Dim instance As NamedStyleCollection
     
    instance.Clear()
    public virtual void Clear()
    Example
    This example clears the range of styles from the NamedStyleCollection object.
    FarPoint.Web.Spread.NamedStyleCollection nsc = new FarPoint.Web.Spread.NamedStyleCollection();
    FarPoint.Web.Spread.NamedStyle ns = new FarPoint.Web.Spread.NamedStyle("StyleData", "DataAreaDefault");
    FarPoint.Web.Spread.NamedStyle ns1 = new FarPoint.Web.Spread.NamedStyle("HeaderData", "HeaderDefault");
    System.Collections.ArrayList c = new System.Collections.ArrayList(2);
    ns.BackColor = Color.Yellow;
    ns.Border = new FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Blue);
    ns1.BackColor = Color.Teal;
    ns1.Border = new FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Red);
    c.Add(ns);
    c.Add(ns1);
    nsc.AddRange(c);
    FpSpread1.NamedStyles.AddRange(new Object[] {nsc[0], nsc[1]});
    FpSpread1.ActiveSheetView.DefaultStyle = nsc[0];
    FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = nsc[1];
    
    if(IsPostBack)
    {
        nsc.Clear();
        TextBox1.Text = nsc.Count.ToString();
    }
    
    Dim nsc As New FarPoint.Web.Spread.NamedStyleCollection
    Dim ns As New FarPoint.Web.Spread.NamedStyle("StyleData", "DataAreaDefault")
    Dim ns1 As New FarPoint.Web.Spread.NamedStyle("HeaderData", "HeaderDefault")
    Dim c As New System.Collections.ArrayList(2)
    ns.BackColor = Color.Yellow
    ns.Border = New FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Blue)
    ns1.BackColor = Color.Teal
    ns1.Border = New FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Red)
    c.Add(ns)
    c.Add(ns1)
    nsc.AddRange(c)
    FpSpread1.NamedStyles.AddRange(New Object() {nsc(0), nsc(1)})
    FpSpread1.ActiveSheetView.DefaultStyle = nsc(0)
    FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = nsc(1)
    
    If IsPostBack Then
        nsc.Clear()
        TextBox1.Text = nsc.Count.ToString()
    End If
    See Also