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 the named styles in the collection to an array.
| C# |  Copy Code |
|---|
FarPoint.Win.Spread.NamedStyleCollection nsc = new FarPoint.Win.Spread.NamedStyleCollection();
FarPoint.Win.Spread.NamedStyle ns1 = new FarPoint.Win.Spread.NamedStyle("StyleHeaders", "HeaderDefault");
FarPoint.Win.Spread.NamedStyle ns2 = new FarPoint.Win.Spread.NamedStyle("StyleData", "DataAreaDefault");
ns1.BackColor = Color.LightBlue;
ns2.BackColor = Color.Gray;
nsc.AddRange(new Object[] {ns1, ns2});
fpSpread1.NamedStyles = nsc;
fpSpread1.ActiveSheet.ColumnHeader.DefaultStyle = nsc[0];
fpSpread1.ActiveSheet.DefaultStyle = nsc[1];
object[] myarray = new Object[nsc.Count];
nsc.CopyTo(myarray, 0);
label1.Text = "The name of the first style in the collection " + myarray.GetValue(0).ToString(); |
| Visual Basic | Copy Code |
|---|
Dim nsc As New FarPoint.Win.Spread.NamedStyleCollection()
Dim ns1 As New FarPoint.Win.Spread.NamedStyle("StyleHeaders", "HeaderDefault")
Dim ns2 As New FarPoint.Win.Spread.NamedStyle("StyleData", "DataAreaDefault")
ns1.BackColor = Color.LightBlue
ns2.BackColor = Color.Gray
nsc.AddRange(New Object() {ns1, ns2})
FpSpread1.NamedStyles = nsc
FpSpread1.ActiveSheet.ColumnHeader.DefaultStyle = nsc(0)
FpSpread1.ActiveSheet.DefaultStyle = nsc(1)
Dim myarray(nsc.Count())
nsc.CopyTo(myarray, 0)
Label1.Text = "The name of the first style in the collection " & myarray.GetValue(0).ToString() |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
