Spread for ASP.NET 7.0 Product Documentation
RemoveAt Method
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > NamedStyleCollection Class : RemoveAt Method


index
Zero-based index of the style to be removed

Glossary Item Box

Removes a named style (NamedStyle object) from the collection at the specified index.

Syntax

Visual Basic (Declaration) 
Public Overridable Sub RemoveAt( _
   ByVal index As Integer _
) 
Visual Basic (Usage)Copy Code
Dim instance As NamedStyleCollection
Dim index As Integer
 
instance.RemoveAt(index)
C# 
public virtual void RemoveAt( 
   int index
)

Parameters

index
Zero-based index of the style to be removed

Exceptions

ExceptionDescription
System.IndexOutOfRangeException Specified index is out of range; must be between 0 and the total number in the collection

Example

This example removes a style at the specified index in 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");
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});
FpSpread1.NamedStyles.Add(ns1);
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = ns1;
if(IsPostBack)
{
    nsc.RemoveAt(1);
    IEnumerator ie = nsc.GetEnumerator();
    foreach(FarPoint.Web.Spread.NamedStyle n in nsc)
    {
        ie.MoveNext();
        FpSpread1.NamedStyles.Add((FarPoint.Web.Spread.NamedStyle)ie.Current);
        FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = (FarPoint.Web.Spread.NamedStyle)ie.Current;
    }
}
Visual BasicCopy 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 n As FarPoint.Web.Spread.NamedStyle
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})
FpSpread1.NamedStyles.Add(ns1)
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = ns1
If IsPostBack Then
    nsc.RemoveAt(1)
    Dim ie As IEnumerator = nsc.GetEnumerator
    For Each n In nsc
        ie.MoveNext()
        FpSpread1.NamedStyles.Add(ie.Current)
        FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = ie.Current
    Next
End If

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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.