SheetSkin Constructor

SheetSkin(SheetSkin)

Creates a new skin and copies the property values from the source skin.

Declaration

public SheetSkin(SheetSkin source)

Public Sub New(source As SheetSkin)

Parameters

Type	Name	Description
SheetSkin	source	SheetSkin from which to copy, or null to copy from DefaultSkins.Default

SheetSkin(FpSpread)

Creates a new skin with the property values of the active sheet of the specified Spread component.

Declaration

public SheetSkin(FpSpread spread)

Public Sub New(spread As FpSpread)

Parameters

Type	Name	Description
FpSpread	spread	Spread component

SheetSkin(string, Color, Color, Color, Color, GridLines, Color, Color, Color, Color, Color, Color, bool, bool, bool, bool, bool)

Creates a new skin with the specified settings.

Declaration

public SheetSkin(string name, Color backColor, Color cellBackColor, Color cellForeColor, Color gridLineColor, GridLines gridLines, Color headerBackColor, Color headerForeColor, Color selectionBackColor, Color selectionForeColor, Color evenRowBackColor, Color oddRowBackColor, bool flatColumnHeader, bool flatRowHeader, bool headerFontBold, bool showColumnHeader, bool showRowHeader)

Public Sub New(name As String, backColor As Color, cellBackColor As Color, cellForeColor As Color, gridLineColor As Color, gridLines As GridLines, headerBackColor As Color, headerForeColor As Color, selectionBackColor As Color, selectionForeColor As Color, evenRowBackColor As Color, oddRowBackColor As Color, flatColumnHeader As Boolean, flatRowHeader As Boolean, headerFontBold As Boolean, showColumnHeader As Boolean, showRowHeader As Boolean)

Parameters

Type	Name	Description
string	name	Name of the skin
Color	backColor	Background color for the sheet
Color	cellBackColor	Background color of the cells
Color	cellForeColor	Text color of the cells
Color	gridLineColor	Grid line color
GridLines	gridLines	Which grid lines are displayed
Color	headerBackColor	Background color of the headers
Color	headerForeColor	Text color of the headers
Color	selectionBackColor	Background color of selected cells
Color	selectionForeColor	Text color of selected cells
Color	evenRowBackColor	Background color of even rows
Color	oddRowBackColor	Background color of odd rows
bool	flatColumnHeader	Whether flat headers are displayed (or default three-dimensional headers)
bool	flatRowHeader	Whether flat headers are displayed (or default three-dimensional headers)
bool	headerFontBold	Whether to show bold font in headers
bool	showColumnHeader	Whether to display the column header
bool	showRowHeader	Whether to display the row header

SheetSkin(string, Color, Color, Color, Color, GridLines, Color, Color, Color, Color, Color, Color, Color, Color, bool, bool, bool, bool, bool, bool, bool, bool)

Creates a new skin with the specified settings.

Declaration

public SheetSkin(string name, Color backColor, Color cellBackColor, Color cellForeColor, Color gridLineColor, GridLines gridLines, Color headerBackColor, Color footerBackColor, Color headerForeColor, Color footerForeColor, Color selectionBackColor, Color selectionForeColor, Color evenRowBackColor, Color oddRowBackColor, bool flatColumnHeader, bool flatColumnFooter, bool flatRowHeader, bool headerFontBold, bool footerFontBold, bool showColumnHeader, bool showColumnFooter, bool showRowHeader)

Public Sub New(name As String, backColor As Color, cellBackColor As Color, cellForeColor As Color, gridLineColor As Color, gridLines As GridLines, headerBackColor As Color, footerBackColor As Color, headerForeColor As Color, footerForeColor As Color, selectionBackColor As Color, selectionForeColor As Color, evenRowBackColor As Color, oddRowBackColor As Color, flatColumnHeader As Boolean, flatColumnFooter As Boolean, flatRowHeader As Boolean, headerFontBold As Boolean, footerFontBold As Boolean, showColumnHeader As Boolean, showColumnFooter As Boolean, showRowHeader As Boolean)

Parameters

Type	Name	Description
string	name	Name of the skin
Color	backColor	Background color for the sheet
Color	cellBackColor	Background color of the cells
Color	cellForeColor	Text color of the cells
Color	gridLineColor	Grid line color
GridLines	gridLines	Which grid lines are displayed
Color	headerBackColor	Background color of the headers
Color	footerBackColor	Background color of the footers
Color	headerForeColor	Text color of the headers
Color	footerForeColor	Text color of the footers
Color	selectionBackColor	Background color of selected cells
Color	selectionForeColor	Text color of selected cells
Color	evenRowBackColor	Background color of even rows
Color	oddRowBackColor	Background color of odd rows
bool	flatColumnHeader	Whether flat headers are displayed (or default three-dimensional headers)
bool	flatColumnFooter	Whether flat footers are displayed (or default three-dimensional footers)
bool	flatRowHeader	Whether flat headers are displayed (or default three-dimensional headers)
bool	headerFontBold	Whether to show bold font in headers
bool	footerFontBold	Whether to show bold font in footers
bool	showColumnHeader	Whether to display the column header
bool	showColumnFooter	Whether to display the column footer
bool	showRowHeader	Whether to display the row header

SheetSkin(string, Color, Color, Color, Color, GridLines, Color, Color, Color, Color, Color, Color, bool, bool, bool, bool, bool, string, string, string, string)

Creates a new skin with the specified settings.

Declaration

public SheetSkin(string name, Color backColor, Color cellBackColor, Color cellForeColor, Color gridLineColor, GridLines gridLines, Color headerBackColor, Color headerForeColor, Color selectionBackColor, Color selectionForeColor, Color evenRowBackColor, Color oddRowBackColor, bool flatColumnHeader, bool flatRowHeader, bool headerFontBold, bool showColumnHeader, bool showRowHeader, string columnHeaderParent, string rowHeaderParent, string dataAreaParent, string cornerParent)

Public Sub New(name As String, backColor As Color, cellBackColor As Color, cellForeColor As Color, gridLineColor As Color, gridLines As GridLines, headerBackColor As Color, headerForeColor As Color, selectionBackColor As Color, selectionForeColor As Color, evenRowBackColor As Color, oddRowBackColor As Color, flatColumnHeader As Boolean, flatRowHeader As Boolean, headerFontBold As Boolean, showColumnHeader As Boolean, showRowHeader As Boolean, columnHeaderParent As String, rowHeaderParent As String, dataAreaParent As String, cornerParent As String)

Parameters

Type	Name	Description
string	name	Name of the skin
Color	backColor	Background color for the sheet
Color	cellBackColor	Background color of the cells
Color	cellForeColor	Text color of the cells
Color	gridLineColor	Grid line color
GridLines	gridLines	Which grid lines are displayed
Color	headerBackColor	Background color of the headers
Color	headerForeColor	Text color of the headers
Color	selectionBackColor	Background color of selected cells
Color	selectionForeColor	Text color of selected cells
Color	evenRowBackColor	Background color of even rows
Color	oddRowBackColor	Background color of odd rows
bool	flatColumnHeader	Whether flat headers are displayed (or default three-dimensional headers)
bool	flatRowHeader	Whether flat headers are displayed (or default three-dimensional headers)
bool	headerFontBold	Whether to show bold font in headers
bool	showColumnHeader	Whether to display the column header
bool	showRowHeader	Whether to display the row header
string	columnHeaderParent	Parent column header
string	rowHeaderParent	Row header parent
string	dataAreaParent	Data area parent
string	cornerParent	Sheet corner parent

SheetSkin(string, Color, Color, Color, Color, GridLines, Color, Color, Color, Color, Color, Color, bool, bool, bool, bool, bool, string, string, string, string, string, string, Color, Color, Color, Color, AutoFilterMode)

Creates a new skin with the specified settings.

Declaration

public SheetSkin(string name, Color backColor, Color cellBackColor, Color cellForeColor, Color gridLineColor, GridLines gridLines, Color headerBackColor, Color headerForeColor, Color selectionBackColor, Color selectionForeColor, Color evenRowBackColor, Color oddRowBackColor, bool flatColumnHeader, bool flatRowHeader, bool headerFontBold, bool showColumnHeader, bool showRowHeader, string columnHeaderParent, string rowHeaderParent, string dataAreaParent, string cornerParent, string filterBarParent, string filterBarHeaderParent, Color filterBarBackColor, Color filterBarForeColor, Color filterBarHeaderBackColor, Color filterBarHeaderForeColor, AutoFilterMode autoFilterMode)

Public Sub New(name As String, backColor As Color, cellBackColor As Color, cellForeColor As Color, gridLineColor As Color, gridLines As GridLines, headerBackColor As Color, headerForeColor As Color, selectionBackColor As Color, selectionForeColor As Color, evenRowBackColor As Color, oddRowBackColor As Color, flatColumnHeader As Boolean, flatRowHeader As Boolean, headerFontBold As Boolean, showColumnHeader As Boolean, showRowHeader As Boolean, columnHeaderParent As String, rowHeaderParent As String, dataAreaParent As String, cornerParent As String, filterBarParent As String, filterBarHeaderParent As String, filterBarBackColor As Color, filterBarForeColor As Color, filterBarHeaderBackColor As Color, filterBarHeaderForeColor As Color, autoFilterMode As AutoFilterMode)

Parameters

Type	Name	Description
string	name	Name of the skin
Color	backColor	Background color for the sheet
Color	cellBackColor	Background color of the cells
Color	cellForeColor	Text color of the cells
Color	gridLineColor	Grid line color
GridLines	gridLines	Which grid lines are displayed
Color	headerBackColor	Background color of the headers
Color	headerForeColor	Text color of the headers
Color	selectionBackColor	Background color of selected cells
Color	selectionForeColor	Text color of selected cells
Color	evenRowBackColor	Background color of even rows
Color	oddRowBackColor	Background color of odd rows
bool	flatColumnHeader	Whether flat headers are displayed (or default three-dimensional headers)
bool	flatRowHeader	Whether flat headers are displayed (or default three-dimensional headers)
bool	headerFontBold	Whether to show bold font in headers
bool	showColumnHeader	Whether to display the column header
bool	showRowHeader	Whether to display the row header
string	columnHeaderParent	Parent column header
string	rowHeaderParent	Row header parent
string	dataAreaParent	Data area parent
string	cornerParent	Sheet corner parent
string	filterBarParent	Filter bar parent
string	filterBarHeaderParent	Filter bar header parent
Color	filterBarBackColor	Backround color of the filter bar
Color	filterBarForeColor	Text color of the filter bar
Color	filterBarHeaderBackColor	Background color of the filter bar header
Color	filterBarHeaderForeColor	Text color of the filter bar header
AutoFilterMode	autoFilterMode	AutoFilterMode for the sheet

SheetSkin(string, Color, Color, Color, Color, GridLines, Color, Color, Color, Color, Color, Color, Color, Color, bool, bool, bool, bool, bool, bool, bool, bool, string, string, string, string, string)

Creates a new skin with the specified settings.

Declaration

public SheetSkin(string name, Color backColor, Color cellBackColor, Color cellForeColor, Color gridLineColor, GridLines gridLines, Color headerBackColor, Color footerBackColor, Color headerForeColor, Color footerForeColor, Color selectionBackColor, Color selectionForeColor, Color evenRowBackColor, Color oddRowBackColor, bool flatColumnHeader, bool flatColumnFooter, bool flatRowHeader, bool headerFontBold, bool footerFontBold, bool showColumnHeader, bool showColumnFooter, bool showRowHeader, string columnHeaderParent, string columnFooterParent, string rowHeaderParent, string dataAreaParent, string cornerParent)

Public Sub New(name As String, backColor As Color, cellBackColor As Color, cellForeColor As Color, gridLineColor As Color, gridLines As GridLines, headerBackColor As Color, footerBackColor As Color, headerForeColor As Color, footerForeColor As Color, selectionBackColor As Color, selectionForeColor As Color, evenRowBackColor As Color, oddRowBackColor As Color, flatColumnHeader As Boolean, flatColumnFooter As Boolean, flatRowHeader As Boolean, headerFontBold As Boolean, footerFontBold As Boolean, showColumnHeader As Boolean, showColumnFooter As Boolean, showRowHeader As Boolean, columnHeaderParent As String, columnFooterParent As String, rowHeaderParent As String, dataAreaParent As String, cornerParent As String)

Parameters

Type	Name	Description
string	name	Name of the skin
Color	backColor	Background color for the sheet
Color	cellBackColor	Background color of the cells
Color	cellForeColor	Text color of the cells
Color	gridLineColor	Grid line color
GridLines	gridLines	Which grid lines are displayed
Color	headerBackColor	Background color of the headers
Color	footerBackColor	Background color of the footers
Color	headerForeColor	Text color of the headers
Color	footerForeColor	Text color of the footers
Color	selectionBackColor	Background color of selected cells
Color	selectionForeColor	Text color of selected cells
Color	evenRowBackColor	Background color of even rows
Color	oddRowBackColor	Background color of odd rows
bool	flatColumnHeader	Whether flat headers are displayed (or default three-dimensional headers)
bool	flatColumnFooter	Whether flat footers are displayed (or default three-dimensional footers)
bool	flatRowHeader	Whether flat headers are displayed (or default three-dimensional headers)
bool	headerFontBold	Whether to display bold font in headers
bool	footerFontBold	Whether to display bold font in footers
bool	showColumnHeader	Whether to display the column header
bool	showColumnFooter	Whether to display the column footer
bool	showRowHeader	Whether to display the row header
string	columnHeaderParent	Parent column header
string	columnFooterParent	Parent column footer
string	rowHeaderParent	Row header parent
string	dataAreaParent	Data area parent
string	cornerParent	Sheet corner parent

SheetSkin(string, Color, Color, Color, Color, GridLines, Color, Color, Color, Color, Color, Color, Color, Color, bool, bool, bool, bool, bool, bool, bool, bool, string, string, string, string, string, string, string, Color, Color, Color, Color, AutoFilterMode)

Creates a new skin with the specified settings.

Declaration

public SheetSkin(string name, Color backColor, Color cellBackColor, Color cellForeColor, Color gridLineColor, GridLines gridLines, Color headerBackColor, Color footerBackColor, Color headerForeColor, Color footerForeColor, Color selectionBackColor, Color selectionForeColor, Color evenRowBackColor, Color oddRowBackColor, bool flatColumnHeader, bool flatColumnFooter, bool flatRowHeader, bool headerFontBold, bool footerFontBold, bool showColumnHeader, bool showColumnFooter, bool showRowHeader, string columnHeaderParent, string columnFooterParent, string rowHeaderParent, string dataAreaParent, string cornerParent, string filterBarParent, string filterBarHeaderParent, Color filterBarBackColor, Color filterBarForeColor, Color filterBarHeaderBackColor, Color filterBarHeaderForeColor, AutoFilterMode autoFilterMode)

Public Sub New(name As String, backColor As Color, cellBackColor As Color, cellForeColor As Color, gridLineColor As Color, gridLines As GridLines, headerBackColor As Color, footerBackColor As Color, headerForeColor As Color, footerForeColor As Color, selectionBackColor As Color, selectionForeColor As Color, evenRowBackColor As Color, oddRowBackColor As Color, flatColumnHeader As Boolean, flatColumnFooter As Boolean, flatRowHeader As Boolean, headerFontBold As Boolean, footerFontBold As Boolean, showColumnHeader As Boolean, showColumnFooter As Boolean, showRowHeader As Boolean, columnHeaderParent As String, columnFooterParent As String, rowHeaderParent As String, dataAreaParent As String, cornerParent As String, filterBarParent As String, filterBarHeaderParent As String, filterBarBackColor As Color, filterBarForeColor As Color, filterBarHeaderBackColor As Color, filterBarHeaderForeColor As Color, autoFilterMode As AutoFilterMode)

Parameters

Type	Name	Description
string	name	Name of the skin
Color	backColor	Background color for the sheet
Color	cellBackColor	Background color of the cells
Color	cellForeColor	Text color of the cells
Color	gridLineColor	Grid line color
GridLines	gridLines	Which grid lines are displayed
Color	headerBackColor	Background color of the headers
Color	footerBackColor	Background color of the footers
Color	headerForeColor	Text color of the headers
Color	footerForeColor	Text color of the footers
Color	selectionBackColor	Background color of selected cells
Color	selectionForeColor	Text color of selected cells
Color	evenRowBackColor	Background color of even rows
Color	oddRowBackColor	Background color of odd rows
bool	flatColumnHeader	Whether flat headers are displayed (or default three-dimensional headers)
bool	flatColumnFooter	Whether flat footers are displayed (or default three-dimensional footers)
bool	flatRowHeader	Whether flat headers are displayed (or default three-dimensional headers)
bool	headerFontBold	Whether to show bold font in headers
bool	footerFontBold	Whether to show bold font in footers
bool	showColumnHeader	Whether to display the column header
bool	showColumnFooter	Whether to display the column footer
bool	showRowHeader	Whether to display the row header
string	columnHeaderParent	Parent column header
string	columnFooterParent	Parent column footer
string	rowHeaderParent	Row header parent
string	dataAreaParent	Data area parent
string	cornerParent	Sheet corner parent
string	filterBarParent	Filter bar parent
string	filterBarHeaderParent	Filter bar header parent
Color	filterBarBackColor	Backround color of the filter bar
Color	filterBarForeColor	Text color of the filter bar
Color	filterBarHeaderBackColor	Background color of the filter bar header
Color	filterBarHeaderForeColor	Text color of the filter bar header
AutoFilterMode	autoFilterMode	AutoFilterMode for the sheet

SheetSkin(SheetView)

Creates a new skin with the property settings of the specified sheet.

Declaration

public SheetSkin(SheetView sheetView)

Public Sub New(sheetView As SheetView)

Parameters

Type	Name	Description
SheetView	sheetView	Sheet (SheetView object), or null to initialize using DefaultSkins.Default

SheetSkin(SerializationInfo, StreamingContext)

Creates a new skin from serialization.

Declaration

protected SheetSkin(SerializationInfo info, StreamingContext context)

Protected Sub New(info As SerializationInfo, context As StreamingContext)

Parameters

Type	Name	Description
SerializationInfo	info	SerializationInfo
StreamingContext	context	StreamingContext