Adds an array of styles (NamedStyle objects) to the collection.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Overloads Overridable Sub AddRange( _
ByVal c As ICollection _
) |
Parameters
- c
- ICollection object containing the styles to add to the collection
Remarks
Example
This example adds a range of styles to the collection.
| 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];
|
| 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) |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
