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 instructions for applying the built-in skins, see Applying a Skin to the Component.
For more information on cell-level styles, refer to Creating and Applying a Style for Cells.
For instructions on saving the skin to a file or stream, refer to Saving and Loading a Skin.
For information on the underlying model for skins, refer to Understanding the Style Model.
For information on customizing a skin in the Spread Designer, refer to the SpreadSkin Editor in the Spread Designer Guide.
For more details about sheet skins, refer to the SheetSkin class.
Using the SpreadSkin Editor
- In the Form window, click the Spread component for which you want to create the skin.
- At the bottom of the Properties window, click the Edit Skins verb.
- In the SpreadSkin Editor, select the Custom tab.
- Set the properties in the Custom tab to create the skin you want.
- Set the Name property to specify the name for your custom skin.
- Click the Save Skin button to save the skin.
A dialog appears saying the skin has been saved.
- Click OK to close the editor and apply the skin you created to the sheet, or click Cancel to close the editor and not apply the skin you created.
Using a Shortcut
- Use the SpreadSkin object constructor, and set its parameters to specify the settings for the skin.
- Use the Apply method of the SpreadSkin object to apply it to the component.
Example
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) |
Using the Spread Designer
- From the Settings menu, choose the SpreadSkin icon.
- In the Spread Skin Editor, select the Custom tab.
- Set the properties for the new custom skin, including the Name property to name your skin.
- Select the Save Skin button.
A message box appears telling you your custom skin has been saved.
- Click OK to close the Spread Skin Editor.
- From the File menu choose Apply and Exit to apply your changes to the component and exit Spread Designer.