You can quickly customize the appearance of the spreadsheet component by applying a "skin" to it. Some built-in skins are provided with Spread to create common formats. You can create your own custom skin and save it to use again, similar to a template.
For more information and instructions about | See |
---|---|
Applying the built-in skins | Applying a Skin to the Component |
Creating and applying your own cell-level styles | Creating and Applying a Style for Cells |
Saving the skin to a file or stream | Saving and Loading a Skin |
Underlying model for skins | Understanding the Style Model |
Customizing a skin in the Spread Designer | SpreadSkin Editor |
Spread skins | SpreadSkin class |
A dialog appears saying the skin has been saved.
This example code creates and uses a custom skin.
C# |
Copy Code
|
---|---|
fpSpread1.Sheets.Count = 3; FarPoint.Win.Spread.StyleInfo chd = new FarPoint.Win.Spread.StyleInfo(); chd.BackColor = Color.LightGreen; FarPoint.Win.Spread.StyleInfo cds = new FarPoint.Win.Spread.StyleInfo(); cds.BackColor = Color.LightGreen; FarPoint.Win.Spread.StyleInfo rhd = new FarPoint.Win.Spread.StyleInfo(); rhd.BackColor = Color.LightGreen; FarPoint.Win.Spread.StyleInfo def = new FarPoint.Win.Spread.StyleInfo(); FarPoint.Win.Spread.GradientSelectionRenderer gsr = new FarPoint.Win.Spread.GradientSelectionRenderer(); gsr.Color1 = Color.Green; gsr.Color2 = Color.LightGreen; gsr.Opacity = 50; def.BackColor = Color.Honeydew; FarPoint.Win.Spread.EnhancedInterfaceRenderer int1 = new FarPoint.Win.Spread.EnhancedInterfaceRenderer(); int1.ArrowColorDisabled = Color.Green; int1.ArrowColorEnabled = Color.LightSeaGreen; int1.ScrollBoxBackgroundColor = Color.Aqua; int1.TabShape = FarPoint.Win.Spread.EnhancedInterfaceRenderer.SheetTabShape.RoundedRectangle; int1.TabStripButtonStyle = FarPoint.Win.Spread.EnhancedInterfaceRenderer.ButtonStyles.Enhanced; int1.TabStripButtonFlatStyle = FlatStyle.Popup; int1.SheetTabBorderColor = Color.Aquamarine; int1.SheetTabLowerActiveColor = Color.DarkSeaGreen; int1.SheetTabLowerNormalColor = Color.DarkOliveGreen; int1.SheetTabUpperActiveColor = Color.ForestGreen; int1.SheetTabUpperNormalColor = Color.LightSeaGreen; int1.SplitBarBackgroundColor = Color.Aquamarine; int1.SplitBarDarkColor = Color.DarkGreen; int1.SplitBarLightColor = Color.LightGreen; int1.SplitBoxBackgroundColor = Color.Green; int1.SplitBoxBorderColor = Color.LimeGreen; int1.TabStripBackgroundColor = Color.Aquamarine; FarPoint.Win.Spread.NamedStyle chstyle = new FarPoint.Win.Spread.NamedStyle("ColumnHeaders", "HeaderDefault", chd); FarPoint.Win.Spread.NamedStyle corner = new FarPoint.Win.Spread.NamedStyle("CornerHeaders", "HeaderDefault", cds); FarPoint.Win.Spread.NamedStyle rowhstyle = new FarPoint.Win.Spread.NamedStyle("RowHeaders", "HeaderDefault", rhd); FarPoint.Win.Spread.NamedStyle ds = new FarPoint.Win.Spread.NamedStyle("Default", "DataAreaDefault", def); FarPoint.Win.Spread.MarqueeFocusIndicatorRenderer focusrend = new FarPoint.Win.Spread.MarqueeFocusIndicatorRenderer(Color.LightSeaGreen, 2); FarPoint.Win.Spread.EnhancedScrollBarRenderer ScrollBarR = new FarPoint.Win.Spread.EnhancedScrollBarRenderer(Color.Green, Color.LightGreen, Color.Green, Color.Aqua,Color.DarkGreen, Color.DarkSeaGreen, Color.Turquoise, Color.SpringGreen, Color.Teal, Color.PaleGreen, Color.ForestGreen); FarPoint.Win.Spread.SpreadSkin skin = new FarPoint.Win.Spread.SpreadSkin("MySkin", int1, ScrollBarR, focusrend, gsr, ds, chstyle, rowhstyle, corner); skin.Apply(fpSpread1); |
VB |
Copy Code
|
---|---|
' Create a custom skin. fpSpread1.Sheets.Count = 3 Dim chd As New FarPoint.Win.Spread.StyleInfo chd.BackColor = Color.LightGreen Dim cds As New FarPoint.Win.Spread.StyleInfo cds.BackColor = Color.LightGreen Dim rhd As New FarPoint.Win.Spread.StyleInfo rhd.BackColor = Color.LightGreen Dim def As New FarPoint.Win.Spread.StyleInfo Dim gsr As New FarPoint.Win.Spread.GradientSelectionRenderer gsr.Color1 = Color.Green gsr.Color2 = Color.LightGreen gsr.LinearGradientMode = Drawing2D.LinearGradientMode.BackwardDiagonal gsr.Opacity = 50 def.BackColor = Color.Honeydew Dim int As New FarPoint.Win.Spread.EnhancedInterfaceRenderer int.ArrowColorDisabled = Color.Green int.ArrowColorEnabled = Color.LightSeaGreen int.ScrollBoxBackgroundColor = Color.Aqua int.TabShape = FarPoint.Win.Spread.EnhancedInterfaceRenderer.SheetTabShape.RoundedRectangle int.TabStripButtonStyle = FarPoint.Win.Spread.EnhancedInterfaceRenderer.ButtonStyles.Enhanced int.TabStripButtonFlatStyle = FlatStyle.Popup int.SheetTabBorderColor = Color.Aquamarine int.SheetTabLowerActiveColor = Color.DarkSeaGreen int.SheetTabLowerNormalColor = Color.DarkOliveGreen int.SheetTabUpperActiveColor = Color.ForestGreen int.SheetTabUpperNormalColor = Color.LightSeaGreen int.SplitBarBackgroundColor = Color.Aquamarine int.SplitBarDarkColor = Color.DarkGreen int.SplitBarLightColor = Color.LightGreen int.SplitBoxBackgroundColor = Color.Green int.SplitBoxBorderColor = Color.LimeGreen int.TabStripBackgroundColor = Color.Aquamarine Dim chstyle As New FarPoint.Win.Spread.NamedStyle("ColumnHeaders", "HeaderDefault", chd) Dim corner As New FarPoint.Win.Spread.NamedStyle("CornerHeaders", "HeaderDefault", cds) Dim rowhstyle As New FarPoint.Win.Spread.NamedStyle("RowHeaders", "HeaderDefault", rhd) Dim ds As New FarPoint.Win.Spread.NamedStyle("Default", "DataAreaDefault", def) Dim focusrend As New FarPoint.Win.Spread.MarqueeFocusIndicatorRenderer(Color.LightSeaGreen, 2) Dim ScrollBarR As New FarPoint.Win.Spread.EnhancedScrollBarRenderer(Color.Green, Color.LightGreen, Color.Green, Color.Aqua, Color.DarkGreen, Color.DarkSeaGreen, Color.Turquoise, Color.SpringGreen, Color.Teal, Color.PaleGreen, Color.ForestGreen) Dim skin As New FarPoint.Win.Spread.SpreadSkin("MySkin", int, ScrollBarR, focusrend, gsr, ds, chstyle, rowhstyle, corner) skin.Apply(fpSpread1) |
A message box appears telling you your custom skin has been saved.