Border Property (Row)

Visual Basic
C#

'Declaration
 
Public Property Border As Border

'Usage
 
Dim instance As Row
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 row

This example creates a spreadsheet with 10 columns and 20 rows. A Row object is then created and assigned to all the rows of the sheet. The background color, foreground color, font face, and height properties are set to various values, and the text inserted into the rows reflects the changes.

C#

FpSpread1.ActiveSheetView.ColumnCount = 10;
FpSpread1.ActiveSheetView.PageSize = 20;
FpSpread1.ActiveSheetView.RowCount = 20;
FarPoint.Web.Spread.Row myrow;  
int i;
for (i = 0; i < FpSpread1.ActiveSheetView.RowCount; i++)
{
  FpSpread1.ActiveSheetView.SetValue(i, 1, "Row Test");
  myrow = FpSpread1.ActiveSheetView.Rows[i];
  myrow.BackColor = Color.Yellow;
  myrow.ForeColor = Color.Red;
  myrow.Font.Bold = true;
  myrow.Font.Name = "Comic Sans MS";
  myrow.Border = bord;
  myrow.Height = 70;
}

Visual Basic

FpSpread1.ActiveSheetView.ColumnCount = 10
FpSpread1.ActiveSheetView.PageSize = 20
FpSpread1.ActiveSheetView.RowCount = 20
Dim myrow As FarPoint.Web.Spread.Row
Dim i As Integer
For i = 0 To FpSpread1.ActiveSheetView.RowCount - 1
  FpSpread1.ActiveSheetView.SetValue(i, 1, "Row Test")
  myrow = FpSpread1.ActiveSheetView.Rows(i)
  myrow.BackColor = Color.Yellow
  myrow.ForeColor = Color.Red
  myrow.Font.Bold = True
  myrow.Font.Name = "Comic Sans MS"
  myrow.Border = bord
  myrow.Height = 70
Next i

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

Row Class
Row Members
Border Class