Clear Method (NamedStyleCollection)

In This Topic

Removes all named styles from the collection.

Syntax

Visual Basic
C#

'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();
}

Visual Basic

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

Reference

NamedStyleCollection Class
NamedStyleCollection Members
AddRange Method
Add Method
CopyTo Method
Insert Method
Remove Method
RemoveAt Method
Count Property

Product Support Forum | Print this page