Removes all named styles from the collection.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Overridable Sub Clear() |
| C# | |
|---|
public virtual void Clear() |
Example
This example clears the range of styles from the NamedStyleCollection object.
| C# |  Copy Code |
|---|
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 | Copy Code |
|---|
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 |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also
