Spread for ASP.NET 11 Product Documentation
Find Method (NamedStyleCollection)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > NamedStyleCollection Class : Find Method
Name of the style to find
Finds a style (NamedStyle object) in the collection with the specified name.
Syntax
'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
Example
This example searches the collection for a style with the specified name.
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;
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
See Also

Reference

NamedStyleCollection Class
NamedStyleCollection Members