Spread ASP.NET 6.0 Product Documentation
CellSpacing Property
See Also  Example Send Feedback
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetSkin Class : CellSpacing Property


Glossary Item Box

Gets the cell spacing that defines the space between table cells in the displayed HTML page for the sheet.

Syntax

Visual Basic (Declaration) 
Public ReadOnly Property CellSpacing As Integer
Visual Basic (Usage)Copy Code
Dim instance As SheetSkin
Dim value As Integer
 
value = instance.CellSpacing
C# 
public int CellSpacing {get;}

Property Value

Integer number of pixels in the table spacing of cells

Remarks

This property sets the distance between the cells on all four sides of the cell.

HTML tables that represent the displayed sheet can specify a spacing for the cells in the table using the CELLSPACING attribute of the TABLE tag. The cell spacing specifies how much space there is between table cells.

To set the cell padding, which is the spacing between borders and contents of a cell, refer to the Margin property for the Cell.

Example

This example shows the use of the property by returning all the properties for the skin.
C#Copy Code
FarPoint.Web.Spread.SheetSkin myskin = new FarPoint.Web.Spread.SheetSkin("TestSkin", Color.LightGoldenrodYellow, Color.Wheat, Color.DarkGreen, 2, Color.YellowGreen, GridLines.Both, Color.Thistle, Color.BlanchedAlmond, Color.Wheat, Color.DarkBlue, Color.Empty, Color.Empty, false, false, true, true, true);
myskin.Apply(FpSpread1);

ListBox1.Items.Add(myskin.BackColor.ToString());
ListBox1.Items.Add(myskin.CellBackColor.ToString());
ListBox1.Items.Add(myskin.CellForeColor.ToString());
ListBox1.Items.Add(myskin.EvenRowBackColor.ToString());
ListBox1.Items.Add(myskin.FlatColumnHeader.ToString());
ListBox1.Items.Add(myskin.FlatRowHeader.ToString());
ListBox1.Items.Add(myskin.GridLineColor.ToString()); 
ListBox1.Items.Add(myskin.GridLines.ToString());
ListBox1.Items.Add(myskin.HeaderBackColor.ToString());
ListBox1.Items.Add(myskin.HeaderFontBold.ToString()); 
ListBox1.Items.Add(myskin.HeaderForeColor.ToString());
ListBox1.Items.Add(myskin.Name.ToString());
ListBox1.Items.Add(myskin.OddRowBackColor.ToString()); 
ListBox1.Items.Add(myskin.SelectionBackColor.ToString());
ListBox1.Items.Add(myskin.SelectionForeColor.ToString());
ListBox1.Items.Add(myskin.ShowColumnHeader.ToString());
ListBox1.Items.Add(myskin.ShowRowHeader.ToString());
Visual BasicCopy Code
Dim myskin As New FarPoint.Web.Spread.SheetSkin("TestSkin", Color.LightGoldenrodYellow, Color.Wheat, Color.DarkGreen, 2, Color.YellowGreen, GridLines.Both, Color.Thistle, Color.BlanchedAlmond, Color.Wheat, Color.DarkBlue, Nothing, Nothing, False, False, True, True, True)
myskin.Apply(FpSpread1)

ListBox1.Items.Add(myskin.BackColor.ToString())
ListBox1.Items.Add(myskin.CellBackColor.ToString())
ListBox1.Items.Add(myskin.CellForeColor.ToString())
ListBox1.Items.Add(myskin.EvenRowBackColor.ToString())
ListBox1.Items.Add(myskin.FlatColumnHeader.ToString())
ListBox1.Items.Add(myskin.FlatRowHeader.ToString())
ListBox1.Items.Add(myskin.GridLineColor.ToString())
ListBox1.Items.Add(myskin.GridLines.ToString())
ListBox1.Items.Add(myskin.HeaderBackColor.ToString())
ListBox1.Items.Add(myskin.HeaderFontBold.ToString())
ListBox1.Items.Add(myskin.HeaderForeColor.ToString())
ListBox1.Items.Add(myskin.Name.ToString())
ListBox1.Items.Add(myskin.OddRowBackColor.ToString())
ListBox1.Items.Add(myskin.SelectionBackColor.ToString())
ListBox1.Items.Add(myskin.SelectionForeColor.ToString())
ListBox1.Items.Add(myskin.ShowColumnHeader.ToString())
ListBox1.Items.Add(myskin.ShowRowHeader.ToString())

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.