Spread Windows Forms 9.0 Product Documentation
SheetSkin Constructor(String,Color,Color,Color,Color,GridLines,Color,Color,Color,Color,Color,Color,Boolean,Boolean,Boolean,Boolean,Boolean,String,String,String,String,String,String,Color,Color,Color,Color,AutoFilterMode)
Example 


Name of the skin
Background color for the sheet
Background color of the cells
Text color of the cells
Grid line color
Which grid lines are displayed
Background color of the headers
Text color of the headers
Background color of selected cells
Text color of selected cells
Background color of even rows
Background color of odd rows
Whether flat headers are displayed (or default three-dimensional headers)
Whether flat headers are displayed (or default three-dimensional headers)
Whether to show bold font in headers
Whether to display the column header
Whether to display the row header
Parent column header
Row header parent
Data area parent
Sheet corner parent
Filter bar parent
Filter bar header parent
Backround color of the filter bar
Text color of the filter bar
Background color of the filter bar header
Text color of the filter bar header
AutoFilterMode for the sheet
Creates a new skin with the specified settings.
Syntax
'Declaration
 
Public Function New( _
   ByVal name As String, _
   ByVal backColor As Color, _
   ByVal cellBackColor As Color, _
   ByVal cellForeColor As Color, _
   ByVal gridLineColor As Color, _
   ByVal gridLines As GridLines, _
   ByVal headerBackColor As Color, _
   ByVal headerForeColor As Color, _
   ByVal selectionBackColor As Color, _
   ByVal selectionForeColor As Color, _
   ByVal evenRowBackColor As Color, _
   ByVal oddRowBackColor As Color, _
   ByVal flatColumnHeader As Boolean, _
   ByVal flatRowHeader As Boolean, _
   ByVal headerFontBold As Boolean, _
   ByVal showColumnHeader As Boolean, _
   ByVal showRowHeader As Boolean, _
   ByVal columnHeaderParent As String, _
   ByVal rowHeaderParent As String, _
   ByVal dataAreaParent As String, _
   ByVal cornerParent As String, _
   ByVal filterBarParent As String, _
   ByVal filterBarHeaderParent As String, _
   ByVal filterBarBackColor As Color, _
   ByVal filterBarForeColor As Color, _
   ByVal filterBarHeaderBackColor As Color, _
   ByVal filterBarHeaderForeColor As Color, _
   ByVal autoFilterMode As AutoFilterMode _
)
'Usage
 
Dim name As String
Dim backColor As Color
Dim cellBackColor As Color
Dim cellForeColor As Color
Dim gridLineColor As Color
Dim gridLines As GridLines
Dim headerBackColor As Color
Dim headerForeColor As Color
Dim selectionBackColor As Color
Dim selectionForeColor As Color
Dim evenRowBackColor As Color
Dim oddRowBackColor As Color
Dim flatColumnHeader As Boolean
Dim flatRowHeader As Boolean
Dim headerFontBold As Boolean
Dim showColumnHeader As Boolean
Dim showRowHeader As Boolean
Dim columnHeaderParent As String
Dim rowHeaderParent As String
Dim dataAreaParent As String
Dim cornerParent As String
Dim filterBarParent As String
Dim filterBarHeaderParent As String
Dim filterBarBackColor As Color
Dim filterBarForeColor As Color
Dim filterBarHeaderBackColor As Color
Dim filterBarHeaderForeColor As Color
Dim autoFilterMode As AutoFilterMode
 
Dim instance As New SheetSkin(name, backColor, cellBackColor, cellForeColor, gridLineColor, gridLines, headerBackColor, headerForeColor, selectionBackColor, selectionForeColor, evenRowBackColor, oddRowBackColor, flatColumnHeader, flatRowHeader, headerFontBold, showColumnHeader, showRowHeader, columnHeaderParent, rowHeaderParent, dataAreaParent, cornerParent, filterBarParent, filterBarHeaderParent, filterBarBackColor, filterBarForeColor, filterBarHeaderBackColor, filterBarHeaderForeColor, autoFilterMode)

Parameters

name
Name of the skin
backColor
Background color for the sheet
cellBackColor
Background color of the cells
cellForeColor
Text color of the cells
gridLineColor
Grid line color
gridLines
Which grid lines are displayed
headerBackColor
Background color of the headers
headerForeColor
Text color of the headers
selectionBackColor
Background color of selected cells
selectionForeColor
Text color of selected cells
evenRowBackColor
Background color of even rows
oddRowBackColor
Background color of odd rows
flatColumnHeader
Whether flat headers are displayed (or default three-dimensional headers)
flatRowHeader
Whether flat headers are displayed (or default three-dimensional headers)
headerFontBold
Whether to show bold font in headers
showColumnHeader
Whether to display the column header
showRowHeader
Whether to display the row header
columnHeaderParent
Parent column header
rowHeaderParent
Row header parent
dataAreaParent
Data area parent
cornerParent
Sheet corner parent
filterBarParent
Filter bar parent
filterBarHeaderParent
Filter bar header parent
filterBarBackColor
Backround color of the filter bar
filterBarForeColor
Text color of the filter bar
filterBarHeaderBackColor
Background color of the filter bar header
filterBarHeaderForeColor
Text color of the filter bar header
autoFilterMode
AutoFilterMode for the sheet
Example
This example creates and applies a sheet skin.
FarPoint.Win.Spread.SheetSkin sk = new FarPoint.Win.Spread.SheetSkin("sk", System.Drawing.Color.Aqua, System.Drawing.Color.LightYellow, System.Drawing.Color.Black, System.Drawing.Color.Beige, FarPoint.Win.Spread.GridLines.Both, System.Drawing.Color.AliceBlue, System.Drawing.Color.DarkBlue, System.Drawing.Color.Beige, System.Drawing.Color.DarkSeaGreen, System.Drawing.Color.AntiqueWhite, System.Drawing.Color.LightSlateGray, false, false, true, true, true, "test", "test1", "test2", "test3", "test4", "test5", System.Drawing.Color.Thistle, System.Drawing.Color.Purple, System.Drawing.Color.Bisque, System.Drawing.Color.Black, FarPoint.Win.Spread.AutoFilterMode.FilterBar);
FarPoint.Win.Spread.SheetSkin testskin = new FarPoint.Win.Spread.SheetSkin(sk);
testskin.Apply(fpSpread1);
listBox1.Items.Add(sk.FilterBarHeaderBackColor.ToString());
listBox1.Items.Add(sk.FilterBarHeaderForeColor.ToString());
listBox1.Items.Add(sk.FilterBarBackColor.ToString());
listBox1.Items.Add(sk.FilterBarForeColor.ToString());
listBox1.Items.Add(sk.AutoFilterMode.ToString());
Dim sk As New FarPoint.Win.Spread.SheetSkin("sk", System.Drawing.Color.Aqua, System.Drawing.Color.LightYellow, System.Drawing.Color.Black, System.Drawing.Color.Beige, FarPoint.Win.Spread.GridLines.Both, System.Drawing.Color.AliceBlue, System.Drawing.Color.DarkBlue, System.Drawing.Color.Beige, System.Drawing.Color.DarkSeaGreen, System.Drawing.Color.AntiqueWhite, System.Drawing.Color.LightSlateGray, False, False, True, True, True, "test", "test1", "test2", "test3", "test4", "test5", System.Drawing.Color.Thistle, System.Drawing.Color.Purple, System.Drawing.Color.Bisque, System.Drawing.Color.Black, FarPoint.Win.Spread.AutoFilterMode.FilterBar)
Dim testskin As New FarPoint.Win.Spread.SheetSkin(sk)
testskin.Apply(FpSpread1)
ListBox1.Items.Add(sk.FilterBarHeaderBackColor.ToString())
ListBox1.Items.Add(sk.FilterBarHeaderForeColor.ToString())
ListBox1.Items.Add(sk.FilterBarBackColor.ToString())
ListBox1.Items.Add(sk.FilterBarForeColor.ToString())
ListBox1.Items.Add(sk.AutoFilterMode.ToString())
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

SheetSkin Class
SheetSkin Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.