Spread Windows Forms 9.0 Product Documentation
DefaultSheetStyleModel Constructor(Int32,Int32,NamedStyleCollection)
Example 


Number of rows in the model
Number of columns in the model
NamedStyleCollection collection for the style model
Creates a style model (DefaultSheetStyle model object) with the specified number of rows and columns and named styles collection.
Syntax
'Declaration
 
Public Function New( _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer, _
   ByVal namedStyles As NamedStyleCollection _
)
'Usage
 
Dim rowCount As Integer
Dim columnCount As Integer
Dim namedStyles As NamedStyleCollection
 
Dim instance As New DefaultSheetStyleModel(rowCount, columnCount, namedStyles)
public DefaultSheetStyleModel( 
   int rowCount,
   int columnCount,
   NamedStyleCollection namedStyles
)

Parameters

rowCount
Number of rows in the model
columnCount
Number of columns in the model
namedStyles
NamedStyleCollection collection for the style model
Example
This example assigns the named collection to the style of the active sheet and changes the background color of the second alternating rows collection.
FarPoint.Win.Spread.Model.ISheetStyleModel iStyle; 
FarPoint.Win.Spread.StyleInfo sInfo = new FarPoint.Win.Spread.StyleInfo(); 
FarPoint.Win.Spread.NamedStyleCollection nsc = new
FarPoint.Win.Spread.NamedStyleCollection(); 
FarPoint.Win.Spread.NamedStyle ns = new FarPoint.Win.Spread.NamedStyle(); 
ns.Border = new
FarPoint.Win.BevelBorder(FarPoint.Win.BevelBorderType.Raised,
Color.DarkBlue, Color.LightBlue, 2); 
nsc.Add(ns); 
sInfo.BackColor = Color.LightBlue; 
iStyle = fpSpread1.ActiveSheet.Models.Style; 
iStyle.SetDirectAltRowInfo(0, sInfo); 
FarPoint.Win.Spread.Model.DefaultSheetStyleModel defstyleModel = new
FarPoint.Win.Spread.Model.DefaultSheetStyleModel(10, 10, nsc); 
fpSpread2.ActiveSheet.Models.Style = defstyleModel;
Dim iStyle As FarPoint.Win.Spread.Model.ISheetStyleModel
Dim sInfo As New FarPoint.Win.Spread.StyleInfo()
Dim nsc As New FarPoint.Win.Spread.NamedStyleCollection()
Dim ns As New FarPoint.Win.Spread.NamedStyle()
ns.Border = New
FarPoint.Win.BevelBorder(FarPoint.Win.BevelBorderType.Raised,
Color.DarkBlue, Color.LightBlue, 2)
nsc.Add(ns)
sInfo.BackColor = Color.LightBlue
iStyle = FpSpread1.ActiveSheet.Models.Style
iStyle.SetDirectAltRowInfo(0, sInfo)
Dim defstyleModel As New
FarPoint.Win.Spread.Model.DefaultSheetStyleModel(10, 10, nsc)
FpSpread2.ActiveSheet.Models.Style = defstyleModel
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

DefaultSheetStyleModel Class
DefaultSheetStyleModel Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.