BorderStyleBottom Property

Visual Basic
C#

'Declaration
 
Public Property BorderStyleBottom As BorderStyle

'Usage
 
Dim instance As Border
Dim value As BorderStyle
 
instance.BorderStyleBottom = value
 
value = instance.BorderStyleBottom

public BorderStyle BorderStyleBottom {get; set;}

Property Value

BorderStyle setting for the bottom border

For more information on these border styles, see the BorderStyle enumeration in the Microsoft .NET Framework Reference.

If you want to set the border style for all sides of the object to the same style, use the BorderStyle property.

To check if other border style properties have been set, use the IsDefined method.

This example creates a spreadsheet with 7 columns and 50 rows. It sets the first column of cells to be currency cells with a double border on the bottom and left side of the cells and a groove border on the right and top of the cells. The bottom and left side have a 5-pixel thick blue border.

C#

FarPoint.Web.Spread.CurrencyCellType currcell = new FarPoint.Web.Spread.CurrencyCellType();
FarPoint.Web.Spread.Border aborder = new FarPoint.Web.Spread.Border();
FarPoint.Web.Spread.StyleInfo currstyle = new FarPoint.Web.Spread.StyleInfo();
FpSpread1.Sheets[0].ColumnCount = 7;
FpSpread1.Sheets[0].RowCount = 50;
currcell.Size = 20;
aborder.BorderColorBottom = Color.Blue;
aborder.BorderColorLeft = Color.Blue;
aborder.BorderSize = 5;
aborder.BorderStyleBottom = BorderStyle.Double;
aborder.BorderStyleLeft = BorderStyle.Double;
aborder.BorderStyleRight = BorderStyle.Groove;
aborder.BorderStyleTop = BorderStyle.Groove;
currstyle.CellType = currcell;
currstyle.Border = aborder;
FpSpread1.Sheets[0].SetStyleInfo(-1, 0, currstyle);

Visual Basic

Dim currcell As New FarPoint.Web.Spread.CurrencyCellType()
Dim aborder As New FarPoint.Web.Spread.Border()
Dim currstyle As New FarPoint.Web.Spread.StyleInfo()
FpSpread1.Sheets(0).ColumnCount = 7
FpSpread1.Sheets(0).RowCount = 50
currcell.Size = 20
aborder.BorderColorBottom = Color.Blue
aborder.BorderColorLeft = Color.Blue
aborder.BorderSize = 5
aborder.BorderStyleBottom = BorderStyle.Double
aborder.BorderStyleLeft = BorderStyle.Double
aborder.BorderStyleRight = BorderStyle.Groove
aborder.BorderStyleTop = BorderStyle.Groove
currstyle.CellType = currcell
currstyle.Border = aborder
FpSpread1.Sheets(0).SetStyleInfo(-1, 0, currstyle)

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

Border Class
Border Members
BorderStyle Property
IsDefined Method