Find Method (NamedStyleCollection)

Visual Basic
C#

'Declaration
 
Public Overridable Function Find( _
   ByVal name As String _
) As NamedStyle

'Usage
 
Dim instance As NamedStyleCollection
Dim name As String
Dim value As NamedStyle
 
value = instance.Find(name)

public virtual NamedStyle Find( 
   string name
)

Parameters

name: Name of the style to find

Return Value

NamedStyle object in the collection with the specified name or null if no style is found

This example searches the collection for a style with the specified name.

C#

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});
FarPoint.Web.Spread.NamedStyle c;
c = nsc.Find("HeaderData");
if(c.Name == "HeaderData")
{
    c.BackColor = Color.Tan;
}
FpSpread1.NamedStyles.Add(c);
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = c;

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 As FarPoint.Web.Spread.NamedStyle
c = nsc.Find("HeaderData")
If c.Name = "HeaderData" Then
    c.BackColor = Color.Tan
End If
FpSpread1.NamedStyles.Add(c)
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = c

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

NamedStyleCollection Class
NamedStyleCollection Members