NamedStyles Property (FpSpread) | Spread Windows Forms 13.0 Product Documentation

NamedStyles Property (FpSpread)

In This Topic

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

Syntax

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

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;

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

Reference

FpSpread Class
FpSpread Members

User-Task Documentation

Creating and Applying a Style for Cells

Product Support Forum | Print this page