NamedStyles Property (FpSpread)

Visual Basic
C#

'Declaration
 
Public ReadOnly Property NamedStyles As NamedStyleCollection

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

public NamedStyleCollection NamedStyles {get;}

Property Value

NamedStyleCollection containing the styles

By default, this collection is shared between all sheets and style models in the component. When set, all style models that implement the INamedStyleSupport interface in the sheet are updated to reference the new collection.

This example creates two objects for the spreadsheet, a ColumnHeader and a NamedStyle. The NamedStyles background color is set to yellow, and is then applied to the ColumnHeader object, resulting in all the column headers having a background color of yellow.

C#

FarPoint.Web.Spread.ColumnHeader colhdr;
FarPoint.Web.Spread.NamedStylemn style=new FarPoint.Web.Spread.NamedStyle();
mnstyle.Name="fpstyle";
mnstyle.BackColor=Color.Yellow;
FpSpread1.NamedStyles.Add(mnstyle);
colhdr=FpSpread1.ActiveSheetView.ColumnHeader;
colhdr.DefaultStyleName=mnstyle.Name;

Visual Basic

Dim colhdr As FarPoint.Web.Spread.ColumnHeader
Dim mnstyle As New FarPoint.Web.Spread.NamedStyle()
mnstyle.Name="fpstyle"
mnstyle.BackColor=Color.Yellow
FpSpread1.NamedStyles.Add(mnstyle)
colhdr=FpSpread1.ActiveSheetView.ColumnHeader
colhdr.DefaultStyleName=mnstyle.Name

Reference

FpSpread Class
FpSpread Members
NamedStyle Class
NamedStyleCollection Class

User-Task Documentation

Style for Cells