Spread Windows Forms 11.0 Product Documentation
NamedStyles Property (FpSpread)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class : NamedStyles Property
Gets or sets a pre-defined style (NamedStyleCollection object).
Syntax
'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
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.
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;
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
See Also

Reference

FpSpread Class
FpSpread Members
NamedStyle Class

User-Task Documentation

Creating and Applying a Style for Cells