Font Property (HierBarInfo)

Gets or sets the font information for the hierarchy bar in the Spread component.

Syntax

Visual Basic
C#

'Declaration
 
Public Property Font As FontInfo

'Usage
 
Dim instance As HierBarInfo
Dim value As FontInfo
 
instance.Font = value
 
value = instance.Font

public FontInfo Font {get; set;}

Property Value

FontInfo object that contains the font settings

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 object.

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

Example

FpSpread1.HierarchicalView = false;

FarPoint.Web.Spread.HierBarInfo hb;
hb = FpSpread1.HierBar;
hb.Align = HorizontalAlign.Right;
hb.BackColor = Color.Yellow;
hb.Font.Bold = true;
hb.Font.Name = "Comic Sans MS";
hb.ForeColor = Color.Green;
hb.ShowParentRow = true;
hb.ShowWholePath = true;

DataSet ds = new System.Data.DataSet(); 
DataTable name; 
DataTable city; 
name = ds.Tables.Add("Customers"); 
name.Columns.AddRange(new DataColumn[] {new DataColumn("LastName", typeof(string)), new DataColumn("FirstName", typeof(string)),
new DataColumn("ID", typeof(Int32))}); 
name.Rows.Add(new object[] {"Fielding", "William", 0}); 
name.Rows.Add(new object[] {"Williams", "Arthur", 1}); 
name.Rows.Add(new object[] {"Zuchini", "Theodore", 2}); 
city = ds.Tables.Add("City/State"); 
city.Columns.AddRange(new DataColumn[] {new DataColumn("City", typeof(string)), new DataColumn("Owner", typeof(Int32)), new
DataColumn("State", typeof(string))}); 
city.Rows.Add(new object[] {"Atlanta", 0, "Georgia"}); 
city.Rows.Add(new object[] {"Boston", 1, "Mass."}); 
city.Rows.Add(new object[] {"Tampa", 2, "Fla."}); 
ds.Relations.Add("City/State", name.Columns["ID"], city.Columns["Owner"]);

FpSpread1.DataSource = ds;

Visual Basic

FpSpread1.HierarchicalView = False

Dim hb As FarPoint.Web.Spread.HierBarInfo
hb = FpSpread1.HierBar
hb.Align = HorizontalAlign.Right
hb.BackColor = Color.Yellow
hb.Font.Bold = True
hb.Font.Name = "Comic Sans MS"
hb.ForeColor = Color.Green
hb.ShowParentRow = True
hb.ShowWholePath = True

Dim ds As New System.Data.DataSet
Dim name As DataTable
Dim city As DataTable
name = ds.Tables.Add("Customers")
name.Columns.AddRange(New DataColumn() {New DataColumn("LastName", Type.GetType("System.String")), New DataColumn("FirstName",
Type.GetType("System.String")), New DataColumn("ID",
Type.GetType("System.Int32"))})
name.Rows.Add(New Object() {"Fielding", "William", 0}) name.Rows.Add(New Object() {"Williams", "Arthur", 1}) name.Rows.Add(New
Object() {"Zuchini", "Theodore", 2}) city = ds.Tables.Add("City/State") city.Columns.AddRange(New DataColumn() {New DataColumn("City",
Type.GetType("System.String")), New DataColumn("Owner", Type.GetType("System.Int32")), New DataColumn("State",
Type.GetType("System.String"))})
city.Rows.Add(New Object() {"Atlanta", 0, "Georgia"}) city.Rows.Add(New Object() {"Boston", 1, "Mass."}) city.Rows.Add(New
Object() {"Tampa", 2, "Fla."}) ds.Relations.Add("City/State", name.Columns("ID"), city.Columns("Owner"))

FpSpread1.DataSource = ds

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

Reference

HierBarInfo Class
HierBarInfo Members