Creates a style model (DefaultSheetStyle model object) with the specified number of rows and columns and named styles collection.
Syntax
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.
C# | Copy Code |
---|
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; |
Visual Basic | Copy Code |
---|
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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also