Creates a style model (DefaultSheetStyle model object) with the specified parent style model and number of rows and columns.
Syntax
Parameters
- rowCount
- Number of rows in the model
- columnCount
- Number of columns in the model
- parent
- Parent style model
Example
This example assigns the style model 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, iStyle);
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, iStyle)
FpSpread2.ActiveSheet.Models.Style = defstyleModel |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also