Gets or sets the default font for text in cells in this row.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property Font As FontInfo |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As Row
Dim value As FontInfo
instance.Font = value
value = instance.Font |
Property Value
FontInfo object containing the font information for cells in this row
Remarks
Example
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# | Copy Code |
|---|
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 | Copy Code |
|---|
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
|
Requirements
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
See Also
