Spread ASP.NET 16
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Cell Class / Formatter Property
Example


In This Topic
    Formatter Property (Cell)
    In This Topic
    Gets or sets the formatter for a cell.
    Syntax
    'Declaration
     
    Public Property Formatter As IFormatter
    'Usage
     
    Dim instance As Cell
    Dim value As IFormatter
     
    instance.Formatter = value
     
    value = instance.Formatter
    public IFormatter Formatter {get; set;}

    Property Value

    IFormatter object containing the formatter for this cell
    Remarks

    The setting for this property can be overridden if a named style is assigned to the cell using the StyleName property, and that named style sets the formatter to use.

    Example
    This example creates a Cell object and an IFormatter object. The IFormatter object is declared as a CurrencyFormatter and is then used as the formatter for the Cell object. To verify this, the Cell objects formatter is returned in a text box.
    FarPoint.Web.Spread.Cell mycell;
    FarPoint.Web.Spread.Renderer.IFormatter formatter;
    mycell=FpSpread1.Cells[0,0];
    formatter=new FarPoint.Web.Spread.Renderer.CurrencyFormatter();
    mycell.Formatter=formatter;
    TextBox1.Text=Convert.ToString(mycell.Formatter);
    Dim mycell As FarPoint.Web.Spread.Cell
    Dim formatter As FarPoint.Web.Spread.Renderer.IFormatter
    mycell=FpSpread1.Cells(0,0)
    formatter=NewFarPoint.Web.Spread.Renderer.CurrencyFormatter()
    mycell.Formatter=formatter
    TextBox1.Text=Convert.ToString(mycell.Formatter)
    See Also