Gets or sets a pre-defined style (NamedStyleCollection object).

Syntax

Visual Basic (Declaration)
Public Property NamedStyles As NamedStyleCollection

Visual Basic (Usage)	Copy Code
Dim instance As FpSpread Dim value As NamedStyleCollection instance.NamedStyles = value value = instance.NamedStyles

C#
public NamedStyleCollection NamedStyles {get; set;}

Property Value

NamedStyleCollection object that contains the collection of styles

Remarks

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.

Example

This example adds a named style to the Spread component.

C#	Copy Code
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;

Copy Code

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	Copy Code
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

Visual Basic

Copy Code

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

Requirements

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

Syntax

Property Value

Remarks

Example

Requirements

See Also

Reference

User-Task Documentation

Spread Windows Forms 7.0 Product Documentation
NamedStyles Property
See Also Example Support Options