TitleInfo Property (SheetView)

Gets the title information of the sheet.

Syntax

Visual Basic
C#

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

Visual Basic

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;

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

SheetView Class
SheetView Members