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


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;
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

Reference

SheetView Class
SheetView Members

 

 


Copyright © GrapeCity, inc. All rights reserved.