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


In This Topic
    CellType Property (TitleInfo)
    In This Topic
    Gets or sets the type of cell for the title bar.
    Syntax
    'Declaration
     
    Public Property CellType As ICellType
    'Usage
     
    Dim instance As TitleInfo
    Dim value As ICellType
     
    instance.CellType = value
     
    value = instance.CellType
    public ICellType CellType {get; set;}

    Property Value

    ICellType that determines the cell type of the title bar
    Example
    This example sets the title info for the first sheet.
    FpSpread1.Sheets[0].TitleInfo.Text = "This is sheet 1";
    FpSpread1.Sheets[0].TitleInfo.Background.BackGroundImageUrl = FarPoint.Web.Spread.Background.DEFAULTGRADIENTMASKIMAGE;
    FpSpread1.Sheets[0].TitleInfo.BackColor = Drawing.Color.Coral;
    FpSpread1.Sheets[0].TitleInfo.Border = new FarPoint.Web.Spread.Border(System.Web.UI.WebControls.BorderStyle.Double, Drawing.Color.DarkKhaki, 2);
    FpSpread1.Sheets[0].TitleInfo.CellType = new FarPoint.Web.Spread.GeneralCellType();
    FpSpread1.Sheets[0].TitleInfo.Font.Bold = true;
    FpSpread1.Sheets[0].TitleInfo.ForeColor = Drawing.Color.DarkKhaki;
    FpSpread1.Sheets[0].TitleInfo.Height = 20;
    FpSpread1.Sheets[0].TitleInfo.HorizontalAlign = HorizontalAlign.Center;
    FpSpread1.Sheets[0].TitleInfo.Margin = new FarPoint.Web.Spread.Inset(10, 10, 10, 10);
    FpSpread1.Sheets[0].TitleInfo.VerticalAlign = VerticalAlign.Middle;
    FpSpread1.Sheets(0).TitleInfo.Text = "This is sheet 1"
    FpSpread1.Sheets(0).TitleInfo.Background.BackGroundImageUrl = FarPoint.Web.Spread.Background.DEFAULTGRADIENTMASKIMAGE
    FpSpread1.Sheets(0).TitleInfo.BackColor = Drawing.Color.Coral
    FpSpread1.Sheets(0).TitleInfo.Border = New FarPoint.Web.Spread.Border(System.Web.UI.WebControls.BorderStyle.Double, Drawing.Color.DarkKhaki, 2)
    FpSpread1.Sheets(0).TitleInfo.CellType = New FarPoint.Web.Spread.GeneralCellType
    FpSpread1.Sheets(0).TitleInfo.Font.Bold = True
    FpSpread1.Sheets(0).TitleInfo.ForeColor = Drawing.Color.DarkKhaki
    FpSpread1.Sheets(0).TitleInfo.Height = 20
    FpSpread1.Sheets(0).TitleInfo.HorizontalAlign = HorizontalAlign.Center
    FpSpread1.Sheets(0).TitleInfo.Margin = New FarPoint.Web.Spread.Inset(10, 10, 10, 10)
    FpSpread1.Sheets(0).TitleInfo.VerticalAlign = VerticalAlign.Middle
    See Also