Formatter Property (Column)

Gets or sets the default formatter for cells in this column.

Syntax

Visual Basic
C#

'Declaration
 
Public Property Formatter As IFormatter

'Usage
 
Dim instance As Column
Dim value As IFormatter
 
instance.Formatter = value
 
value = instance.Formatter

public IFormatter Formatter {get; set;}

Property Value

IFormatter object containing the formatter for cells in this column

Example

This example creates a Column object and an IFormatter object. The IFormatter object is declared as a CurrencyFormatter and is then used as the formatter for the Column object. To verify this, the Column objects formatter is returned in a text box.

FarPoint.Web.Spread.Column mycol;
FarPoint.Web.Spread.Renderer.IFormatter formatter;
mycol=FpSpread1.ActiveSheetView.Columns[0];
formatter=new FarPoint.Web.Spread.Renderer.CurrencyFormatter();
mycol.Formatter=formatter;
TextBox1.Text=Convert.ToString(mycol.Formatter);

Visual Basic

Dim mycol As FarPoint.Web.Spread.Column
Dim formatter As FarPoint.Web.Spread.Renderer.IFormatter
mycol=FpSpread1.ActiveSheetView.Columns(0)
formatter=New FarPoint.Web.Spread.Renderer.CurrencyFormatter()
mycol.Formatter=formatter
TextBox1.Text=Convert.ToString(mycol.Formatter)

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

Column Class
Column Members
IFormatter Interface