Copies the styles in the collection to a specified array at a specified position.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Overloads Overridable Sub CopyTo( _
ByVal array As Array, _
ByVal index As Integer _
) |
Parameters
- array
- One-dimensional array into which are copied the elements from ICollection (The array must have zero-based indexing.)
- index
- Zero-based index in array at which to paste styles
Exceptions
Example
This example copies a style to an array at the specified index.
| 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");
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);
nsc.AddRange(new Object[] {ns, ns1});
object[] c = new Object[nsc.Count];
nsc.CopyTo(c, 0);
FpSpread1.NamedStyles.Add((FarPoint.Web.Spread.NamedStyle)c[0]);
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = (FarPoint.Web.Spread.NamedStyle)c[0];
|
| 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")
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)
nsc.AddRange(New Object() {ns, ns1})
Dim c(nsc.Count)
nsc.CopyTo(c, 0)
FpSpread1.NamedStyles.Add(c(0))
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = c(0) |
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
