Gets the title information of the sheet.
Syntax
| Visual Basic (Declaration) | |
|---|
Public ReadOnly Property TitleInfo As TitleInfo |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As SheetView
Dim value As TitleInfo
value = instance.TitleInfo |
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 | Copy Code |
|---|
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 |
| C# | Copy Code |
|---|
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
See Also
