NamedStyles Property (SheetView)

Visual Basic
C#

'Declaration
 
Public Property NamedStyles As NamedStyleCollection

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

public NamedStyleCollection NamedStyles {get; set;}

Property Value

NamedStyleCollection object containing collection of styles

This property is available at run time only.

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

This example assigns a SheetView object to the active sheet and creates a new NamedStyle object. The BackColor and Border for the NamedStyle are defined, then its added to the NamedStyles collection for the SheetView.

Visual Basic

Dim sv As FarPoint.Web.Spread.SheetView
Dim style1 As New FarPoint.Web.Spread.NamedStyle()
style1.BackColor=Color.Yellow
style1.Border=New FarPoint.Web.Spread.Border(BorderStyle.Dotted,Color.Red,3)
sv=FpSpread1.ActiveSheetView
sv.NamedStyles.Add(style1)
sv.DefaultStyle=style1

C#

FarPoint.Web.Spread.SheetView sv=FpSpread1.ActiveSheetView;
FarPoint.Web.Spread.NamedStyle style1=new FarPoint.Web.Spread.NamedStyle();
style1.BackColor=Color.Yellow;
style1.Border=new FarPoint.Web.Spread.Border(BorderStyle.Dotted,Color.Red,3);
sv.NamedStyles.Add(style1);
sv.DefaultStyle=style1;

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

SheetView Class
SheetView Members
NamedStyleCollection Class
NamedStyle Class

User-Task Documentation

Styles for Cells