Spread for ASP.NET 9.0 Product Documentation
SheetSkin Constructor(String,Color,Color,Color,Int32,Color,GridLines,Color,Color,Color,Color,Color,Color,Boolean,Boolean,Boolean,Boolean,Boolean,String,String,Color,Color,Color,Color,Boolean)
Example 


Name of the skin
Background color for the sheet
Background color of the cells
Text color of the cells
Cell spacing in the table
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 bold font in headers
Whether to display the column header
Whether to display the row header
The filter bar parent.
The filter bar header parent.
Backcolor of the filter bar.
Forecolor of the filter bar.
Backcolor of the filter bar header.
Forecolor of the filter bar header.
if set to true, the filter bar displays.
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 cellSpacing As Integer, _
   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 filterBarParent As String, _
   ByVal filterBarHeaderParent As String, _
   ByVal filterBarBackColor As Color, _
   ByVal filterBarForeColor As Color, _
   ByVal filterBarHeaderBackColor As Color, _
   ByVal filterBarHeaderForeColor As Color, _
   ByVal showFilterBar As Boolean _
)
'Usage
 
Dim name As String
Dim backColor As Color
Dim cellBackColor As Color
Dim cellForeColor As Color
Dim cellSpacing As Integer
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 filterBarParent As String
Dim filterBarHeaderParent As String
Dim filterBarBackColor As Color
Dim filterBarForeColor As Color
Dim filterBarHeaderBackColor As Color
Dim filterBarHeaderForeColor As Color
Dim showFilterBar As Boolean
 
Dim instance As New SheetSkin(name, backColor, cellBackColor, cellForeColor, cellSpacing, gridLineColor, gridLines, headerBackColor, headerForeColor, selectionBackColor, selectionForeColor, evenRowBackColor, oddRowBackColor, flatColumnHeader, flatRowHeader, headerFontBold, showColumnHeader, showRowHeader, filterBarParent, filterBarHeaderParent, filterBarBackColor, filterBarForeColor, filterBarHeaderBackColor, filterBarHeaderForeColor, showFilterBar)

Parameters

name
Name of the skin
backColor
Background color for the sheet
cellBackColor
Background color of the cells
cellForeColor
Text color of the cells
cellSpacing
Cell spacing in the table
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 bold font in headers
showColumnHeader
Whether to display the column header
showRowHeader
Whether to display the row header
filterBarParent
The filter bar parent.
filterBarHeaderParent
The filter bar header parent.
filterBarBackColor
Backcolor of the filter bar.
filterBarForeColor
Forecolor of the filter bar.
filterBarHeaderBackColor
Backcolor of the filter bar header.
filterBarHeaderForeColor
Forecolor of the filter bar header.
showFilterBar
if set to true, the filter bar displays.
Example
This example creates and applies a sheet skin.
FarPoint.Web.Spread.SheetSkin sk = new FarPoint.Web.Spread.SheetSkin("sk", System.Drawing.Color.Aqua, System.Drawing.Color.LightYellow, System.Drawing.Color.Black, 1, System.Drawing.Color.Beige, 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", System.Drawing.Color.Thistle, System.Drawing.Color.Purple, System.Drawing.Color.Bisque, System.Drawing.Color.Black, true);
FarPoint.Web.Spread.SheetSkin testskin = new FarPoint.Web.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.ShowFilterBar.ToString());
Dim sk As New FarPoint.Web.Spread.SheetSkin("sk", Drawing.Color.Aqua, Drawing.Color.LightYellow, Drawing.Color.Black, 1, Drawing.Color.Beige, GridLines.Both, Drawing.Color.AliceBlue, Drawing.Color.DarkBlue, Drawing.Color.Beige, Drawing.Color.DarkSeaGreen, Drawing.Color.AntiqueWhite, Drawing.Color.LightSlateGray, False, False, True, True, True, "test", "test1", Drawing.Color.Thistle, Drawing.Color.Purple, Drawing.Color.Bisque, Drawing.Color.Black, True)
Dim testskin As New FarPoint.Web.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.ShowFilterBar.ToString())
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

SheetSkin Class
SheetSkin Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.