Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Row Class / Font Property
Example


In This Topic
    Font Property (Row)
    In This Topic
    Gets or sets the default font for text in cells in this row.
    Syntax
    'Declaration
     
    Public Property Font As FontInfo
    'Usage
     
    Dim instance As Row
    Dim value As FontInfo
     
    instance.Font = value
     
    value = instance.Font
    public FontInfo Font {get; set;}

    Property Value

    FontInfo object containing the font information for cells in this row
    Remarks

    You can specify several aspects of the font, including the the style, the size, and the face name. For more information on the font settings in general, refer to the FontInfo class members, and for a list of the font styles in particular, refer to the FontStyle enumeration, in the Microsoft .NET Framework Reference.

    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 the font.

    Note: The overline style is not supported in browsers release prior to Internet Explorer 4.

    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.
    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;
    }      
    
    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
    
    See Also