CopyTo(Array,Int32) Method

Copies the styles in the collection to a specified array at a specified position.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Overridable Sub CopyTo( _
   ByVal array As Array, _
   ByVal index As Integer _
)

'Usage
 
Dim instance As NamedStyleCollection
Dim array As Array
Dim index As Integer
 
instance.CopyTo(array, index)

public virtual void CopyTo( 
   Array array,
   int index
)

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

Exception	Description
System.ArgumentNullException	No array specified, or specified array is null (Nothing)
System.ArgumentException	Specified array is not valid; must have a rank of one
System.ArgumentException	Specified array is not valid; must have sufficient length
System.IndexOutOfRangeException	Specified index is out of range; must be greater than zero

Example

This example copies a style to an array at the specified index.

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

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

Reference

NamedStyleCollection Class
NamedStyleCollection Members
Overload List