Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / GeneralCellType Class / PaintCell Method
Example


In This Topic
    PaintCell Method (GeneralCellType)
    In This Topic
    Gets a control and renders it in the cell based on the specified appearance, margin, and value.
    Overload List
    OverloadDescription
    Gets a control and renders it in the cell based on the specified appearance, margin, and value.  
    Gets a control and prints the cell to PDF based on the specified appearance and selection.  
    Example
    This example subclasses the GeneralCellType class and uses it in the first cell of the spreadsheet.
    <Serializable()>Public Class generic
    Inherits FarPoint.Web.Spread.GeneralCellType
    
    Public Overrides Function GetEditorControl(ByVal id As String,ByVal parent As TableCell,ByVal style As FarPoint.Web.Spread.Appearance,ByVal margin As FarPoint.Web.Spread.Inset,ByVal val As Object,ByVal ul As Boolean)As System.Web.UI.Control
    Return MyBase.GetEditorControl(id,parent,style,margin,val,ul)
    End Function
    
    Public Overrides Function PaintCell(ByVal id As String,ByVal parent As TableCell,ByVal style As FarPoint.Web.Spread.Appearance,ByVal margin As FarPoint.Web.Spread.Inset,ByVal val As Object,ByVal ul As Boolean)As System.Web.UI.Control
    Return MyBase.PaintCell(id,parent,style,margin,val,ul)
    End Function
    
    End Class
    
    Private SubPage_Load(ByVal sender As System.Object,ByVal e AsSystem.EventArgs)Handles MyBase.Load
    Dim gencell As New generic()
    FpSpread1.ActiveSheetView.Cells(0,0).CellType=gencell
    FpSpread1.ActiveSheetView.SetValue(0,0,"Thisisatesttoseeifthetextwrapsinthecell")
    FpSpread1.ActiveSheetView.Rows(0).Height=180
    End Sub
    [Serializable()]
    class gentype:FarPoint.Web.Spread.GeneralCellType
    {
    public override Control GetEditorControl(string id,TableCell parent,FarPoint.Web.Spread.Appearance style,FarPoint.Web.Spread.Inset margin,object v,bool ul)
    {
    return base.GetEditorControl(id,parent,style,margin,v,ul);
    }
    public override Control PaintCell(string id,TableCell parent,FarPoint.Web.Spread.Appearance style,FarPoint.Web.Spread.Inset margin,object v,bool ul)
    {
    return base.PaintCell(id,parent,style,margin,v,ul);
    }
    }
    
    private void Page_Load(object sender,System.EventArgs e)
    {
    gentypegencell=new gentype();
    FpSpread1.ActiveSheetView.Cells[0,0].CellType=gencell;
    FpSpread1.ActiveSheetView.SetValue(0,0,"Thisisatesttoseeifthetextwrapsinthecell");
    FpSpread1.ActiveSheetView.Rows[0].Height=180;
    }
    See Also