Border Property (Column)

In This Topic

Gets or sets the default border for cells in this column.

Syntax

Visual Basic
C#

'Declaration
 
Public Property Border As Border

'Usage
 
Dim instance As Column
Dim value As Border
 
instance.Border = value
 
value = instance.Border

public Border Border {get; set;}

Property Value

Border object that contains the border for the cells in this column

Remarks

The setting for this property can be overridden if a named style is assigned to the cell using the StyleName property, and that named style sets a border.

Example

This example creates a spreadsheet with 10 columns and 20 rows. A Column object and a Border object are then created. The Column object is assigned to the second column of the spreadsheet. The Border objects design is assigned to the Border property of the Column object, such that all the cells in the second column have a red, grooved border around them.

FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.PageSize=20;
FpSpread1.ActiveSheetView.RowCount=20;
FarPoint.Web.Spread.Column mycol;
FarPoint.Web.Spread.Border bord=new FarPoint.Web.Spread.Border(BorderStyle.Groove,Color.Red,3);
mycol=FpSpread1.ActiveSheetView.Columns[1];
mycol.Border=bord;

Visual Basic

FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.PageSize=20
FpSpread1.ActiveSheetView.RowCount=20
Dim mycol As FarPoint.Web.Spread.Column
Dim bord As New FarPoint.Web.Spread.Border(BorderStyle.Groove,Color.Red,3)
mycol=FpSpread1.ActiveSheetView.Columns(1)
mycol.Border=bord

Reference

Column Class
Column Members
Border Class

Product Support Forum | Print this page