Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / TitleInfo Property
Example


In This Topic
    TitleInfo Property (SheetView)
    In This Topic
    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