Spread Windows Forms 6.0 Product Documentation
NamedStyles Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class : NamedStyles Property


Glossary Item Box

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;
Visual BasicCopy 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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

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