NamedStyles Property (FpSpread)

Visual Basic
C#

'Declaration
 
Public Property NamedStyles As NamedStyleCollection

'Usage
 
Dim instance As FpSpread
Dim value As NamedStyleCollection
 
instance.NamedStyles = value
 
value = instance.NamedStyles

public NamedStyleCollection NamedStyles {get; set;}

Property Value

NamedStyleCollection object that contains the collection of styles

By default, this collection of named styles is shared between all sheet and style models in the Spread component. When set, any sheet and style model in the component that referenced the old named style (from NamedStyleCollection object) are updated to refer to the new one.

This example adds a named style to the Spread component.

C#

FarPoint.Win.Spread.FpSpread fpSpread1 = new FarPoint.Win.Spread.FpSpread();
FarPoint.Win.Spread.SheetView shv = new FarPoint.Win.Spread.SheetView();
fpSpread1.Location = new Point(10, 10);
fpSpread1.Height = 200;
fpSpread1.Width = 400;
Controls.Add(fpSpread1);
fpSpread1.Sheets.Add(shv);
FarPoint.Win.Spread.NamedStyle ns = new FarPoint.Win.Spread.NamedStyle();
ns.Border = New FarPoint.Win.LineBorder(Color.DarkBlue, 2);
ns.BackColor = Color.LightBlue;
fpSpread1.NamedStyles.Add(ns);
fpSpread1.ActiveSheet.DefaultStyle = ns;

Visual Basic

Dim fpSpread1 As New FarPoint.Win.Spread.FpSpread()
Dim shv As New FarPoint.Win.Spread.SheetView()
fpSpread1.Location = New Point(10, 10)
fpSpread1.Height = 200
fpSpread1.Width = 400
Controls.Add(fpSpread1)
fpSpread1.Sheets.Add(shv)
Dim ns As New FarPoint.Win.Spread.NamedStyle()
ns.Border = New FarPoint.Win.LineBorder(Color.DarkBlue, 2)
ns.BackColor = Color.LightBlue
fpSpread1.NamedStyles.Add(ns)
fpSpread1.ActiveSheet.DefaultStyle = ns

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

Reference

FpSpread Class
FpSpread Members
NamedStyle Class

User-Task Documentation

Creating and Applying a Style for Cells