Spread for ASP.NET 11 Product Documentation
TitleInfo Property (SheetView)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : TitleInfo Property
Gets the title information of the sheet.
Syntax
'Declaration
 
Public ReadOnly Property TitleInfo As TitleInfo
'Usage
 
Dim instance As SheetView
Dim value As TitleInfo
 
value = instance.TitleInfo
public TitleInfo TitleInfo {get;}

Property Value

TitleInfo object containing the appearance settings of the title bar]> This example sets the background (along with other settings) for the title bar.
Example
This example sets the TitleInfo property.
Dim bg As New FarPoint.Web.Spread.Background()
bg.SelectedBackgroundImageUrl = "picture/Winter.jpg"
bg.BackgroundImageUrl = "picture/Image.bmp"
Dim bd1 As New FarPoint.Web.Spread.Border()
bd1.BorderColor = System.Drawing.Color.Blue
bd1.BorderStyle = System.Web.UI.WebControls.BorderStyle.Dashed

FpSpread1.ActiveSheetView.TitleInfo.BackColor = System.Drawing.Color.Pink
FpSpread1.ActiveSheetView.TitleInfo.Background = bg
FpSpread1.ActiveSheetView.TitleInfo.Border = bd1
FpSpread1.ActiveSheetView.TitleInfo.CellType = New FarPoint.Web.Spread.CheckBoxCellType()
FpSpread1.ActiveSheetView.TitleInfo.Font.Bold = True
FpSpread1.ActiveSheetView.TitleInfo.Font.Name = ""
FpSpread1.ActiveSheetView.TitleInfo.ForeColor = System.Drawing.Color.Blue
FpSpread1.ActiveSheetView.TitleInfo.Height = 200
FpSpread1.ActiveSheetView.TitleInfo.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center
FpSpread1.ActiveSheetView.TitleInfo.Margin.Bottom = 10
FpSpread1.ActiveSheetView.TitleInfo.Margin.Left = 10
FpSpread1.ActiveSheetView.TitleInfo.Margin.Right = 10
FpSpread1.ActiveSheetView.TitleInfo.Margin.Top = 10
FpSpread1.ActiveSheetView.TitleInfo.Text = "This is sheet's title"
FpSpread1.ActiveSheetView.TitleInfo.VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle
FpSpread1.ActiveSheetView.TitleInfo.Visible = True
FarPoint.Web.Spread.Background bg = new FarPoint.Web.Spread.Background();
bg.SelectedBackgroundImageUrl = "picture/Winter.jpg";
bg.BackgroundImageUrl = "picture/Image.bmp";
FarPoint.Web.Spread.Border bd1 = new FarPoint.Web.Spread.Border();
bd1.BorderColor = System.Drawing.Color.Blue;
bd1.BorderStyle = System.Web.UI.WebControls.BorderStyle.Dashed;

FpSpread1.ActiveSheetView.TitleInfo.BackColor = System.Drawing.Color.Pink;
FpSpread1.ActiveSheetView.TitleInfo.Background = bg;
FpSpread1.ActiveSheetView.TitleInfo.Border = bd1;
FpSpread1.ActiveSheetView.TitleInfo.CellType = new  FarPoint.Web.Spread.CheckBoxCellType();
FpSpread1.ActiveSheetView.TitleInfo.Font.Bold = true;
FpSpread1.ActiveSheetView.TitleInfo.Font.Name = "";
FpSpread1.ActiveSheetView.TitleInfo.ForeColor = System.Drawing.Color.Blue;
FpSpread1.ActiveSheetView.TitleInfo.Height = 200;
FpSpread1.ActiveSheetView.TitleInfo.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center;
FpSpread1.ActiveSheetView.TitleInfo.Margin.Bottom = 10;
FpSpread1.ActiveSheetView.TitleInfo.Margin.Left = 10;
FpSpread1.ActiveSheetView.TitleInfo.Margin.Right = 10;
FpSpread1.ActiveSheetView.TitleInfo.Margin.Top = 10;
FpSpread1.ActiveSheetView.TitleInfo.Text = "This is sheet's title";
FpSpread1.ActiveSheetView.TitleInfo.VerticalAlign =  System.Web.UI.WebControls.VerticalAlign.Middle;
FpSpread1.ActiveSheetView.TitleInfo.Visible = true;
See Also

Reference

SheetView Class
SheetView Members