Insert Method (NamedStyleCollection)

Visual Basic
C#

'Declaration
 
Public Overridable Sub Insert( _
   ByVal index As Integer, _
   ByVal style As NamedStyle _
)

'Usage
 
Dim instance As NamedStyleCollection
Dim index As Integer
Dim style As NamedStyle
 
instance.Insert(index, style)

public virtual void Insert( 
   int index,
   NamedStyle style
)

Parameters

index: Zero-based index at which to insert the named style
style: Style to insert into the collection

Exception	Description
System.IndexOutOfRangeException	Specified index is out of range; must be between 0 and the total number in the collection
System.ArgumentNullException	No style specified or specified style is null

This example inserts a named style at the specified index into the collection.

C#

FarPoint.Win.Spread.NamedStyleCollection nsc = new FarPoint.Win.Spread.NamedStyleCollection();
FarPoint.Win.Spread.NamedStyle ns1 = new FarPoint.Win.Spread.NamedStyle();
FarPoint.Win.Spread.NamedStyle ns2 = new FarPoint.Win.Spread.NamedStyle();
FarPoint.Win.Spread.NamedStyle ns3 = new FarPoint.Win.Spread.NamedStyle("btncellstyle");
int i;
ns1.BackColor = Color.LightBlue;
ns2.BackColor = Color.Gray;
ns3.CellType = new FarPoint.Win.Spread.CellType.ButtonCellType();
nsc.AddRange(new Object[] {ns1, ns2});
nsc.Insert(1, ns3);
fpSpread1.NamedStyles = nsc;
fpSpread1.ActiveSheet.ColumnHeader.DefaultStyle = nsc[0];
fpSpread1.ActiveSheet.DefaultStyle = nsc[2];
fpSpread1.ActiveSheet.Cells[0, 0].StyleName = "btncellstyle";
i = nsc.IndexOf(ns3);
label1.Text = "The index of btncellstyle in the collection is " + i.ToString();

Visual Basic

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")
Dim ns3 As New FarPoint.Win.Spread.NamedStyle("btncellstyle")
Dim i As Integer
ns1.BackColor = Color.LightBlue
ns2.BackColor = Color.Gray
ns3.CellType = New FarPoint.Win.Spread.CellType.ButtonCellType()
nsc.AddRange(New Object() {ns1, ns2})
nsc.Insert(1, ns3)
FpSpread1.NamedStyles = nsc
FpSpread1.ActiveSheet.ColumnHeader.DefaultStyle = nsc(0)
FpSpread1.ActiveSheet.DefaultStyle = nsc(2)
FpSpread1.ActiveSheet.Cells(0, 0).StyleName = "btncellstyle"
i = nsc.IndexOf(ns3)
Label1.Text = "The index of btncellstyle in the collection is " & i.ToString()

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

NamedStyleCollection Class
NamedStyleCollection Members