Apply(FpSpread) Method

Applies the settings to the Spread component.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Overridable Sub Apply( _
   ByVal spread As FpSpread _
)

'Usage
 
Dim instance As SpreadSkin
Dim spread As FpSpread
 
instance.Apply(spread)

public virtual void Apply( 
   FpSpread spread
)

Parameters

spread: Spread component

Example

This example customizes the skin for the spreadsheet.

fpSpread1.Sheets.Count = 3;
FarPoint.Win.Spread.SpreadSkin skin = new FarPoint.Win.Spread.SpreadSkin();
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.LinearGradientMode = System.Drawing.Drawing2D.LinearGradientMode.BackwardDiagonal;
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;
skin.ColumnHeaderDefaultStyle = new FarPoint.Win.Spread.NamedStyle("ColumnHeaders", "HeaderDefault", chd);
skin.CornerDefaultStyle = new FarPoint.Win.Spread.NamedStyle("CornerHeaders", "HeaderDefault", cds);
skin.RowHeaderDefaultStyle = new FarPoint.Win.Spread.NamedStyle("RowHeaders", "HeaderDefault", rhd);
skin.DefaultStyle = new FarPoint.Win.Spread.NamedStyle("Default", "DataAreaDefault", def);
skin.FocusRenderer = new FarPoint.Win.Spread.MarqueeFocusIndicatorRenderer(Color.LightSeaGreen, 2);
skin.InterfaceRenderer = int1;
skin.Name = "FarPoint Skin";
skin.ScrollBarRenderer = 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);
skin.SelectionRenderer = gsr;
skin.Apply(fpSpread1);
FarPoint.Win.Spread.SpreadSkin.Save(skin, "c:\\forums3\\farpoint.skn");

Visual Basic

FpSpread1.Sheets.Count = 3
Dim skin As New FarPoint.Win.Spread.SpreadSkin()
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
skin.ColumnHeaderDefaultStyle = New FarPoint.Win.Spread.NamedStyle("ColumnHeaders", "HeaderDefault", chd)
skin.CornerDefaultStyle = New FarPoint.Win.Spread.NamedStyle("CornerHeaders", "HeaderDefault", cds)
skin.RowHeaderDefaultStyle = New FarPoint.Win.Spread.NamedStyle("RowHeaders", "HeaderDefault", rhd)
skin.DefaultStyle = New FarPoint.Win.Spread.NamedStyle("Default", "DataAreaDefault", def)
skin.FocusRenderer = New FarPoint.Win.Spread.MarqueeFocusIndicatorRenderer(Color.LightSeaGreen, 2)
skin.InterfaceRenderer = int
skin.Name = "FarPoint Skin"
skin.ScrollBarRenderer = 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)
skin.SelectionRenderer = gsr
skin.Apply(FpSpread1)
FarPoint.Win.Spread.SpreadSkin.Save(skin, "c:\forums3\farpoint.skn")

Reference

SpreadSkin Class
SpreadSkin Members
Overload List