BorderSizeBottom Property

Visual Basic
C#

'Declaration
 
Public Property BorderSizeBottom As Integer

'Usage
 
Dim instance As Border
Dim value As Integer
 
instance.BorderSizeBottom = value
 
value = instance.BorderSizeBottom

public int BorderSizeBottom {get; set;}

Property Value

Integer number of pixels of the thickness of the bottom border

If you want to set the borders for all sides of the object to the same size, use the BorderSize property.

To check if other border size 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 BorderStyle of double-line border. The bottom and right sides of the cells have a blue border that is 5 pixels thick and 8 pixels thick respectively.

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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

Border Class
Border Members
BorderSize Property
IsDefined Method