Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Border Class / BorderSizeTop Property
Example


In This Topic
    BorderSizeTop Property
    In This Topic
    Gets or sets the width in pixels of the top border.
    Syntax
    'Declaration
     
    Public Property BorderSizeTop As Integer
    'Usage
     
    Dim instance As Border
    Dim value As Integer
     
    instance.BorderSizeTop = value
     
    value = instance.BorderSizeTop
    public int BorderSizeTop {get; set;}

    Property Value

    Integer number of pixels of the thickness of the top border
    Remarks

    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.

    Example
    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 top and left sides of the cells have a blue border that is 5 pixels thick and 8 pixels thick respectively.
    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);
    
    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)
    
    See Also