Formatter Property (Cell)

Visual Basic
C#

'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

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.

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.

C#

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

Visual Basic

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)

Reference

Cell Class
Cell Members
IFormatter Interface
StyleName Property
NamedStyle Class