Spread for ASP.NET 9.0 Product Documentation
Formatter Field
Example 


Represents the Formatter property (index of 5) for the formatter of the sheet style.
Syntax
'Declaration
 
Public Shared ReadOnly Formatter As SheetStyleProperty
'Usage
 
Dim value As SheetStyleProperty
 
value = SheetStyleProperty.Formatter
public static readonly SheetStyleProperty Formatter
Example
<Serializable()> 
public class myf : FarPoint.Web.Spread.Renderer.IFormatter
{
    public string Format(object o) 
{
//int ret = o;
    switch (Convert.ToInt32(o))
{
    case 1:
    return "Test1";
    case 2:
    return "Test2";
    case 3:
    return "Test3";
}
return o.ToString();
}

    public object Parse(string s) 
{
    switch (s)
{
    case "Test1":
    return 1;
    case "Test2":
    return 2;
    case "Test3":
    return 3;
}
return s;
}
}

if (IsPostBack)
    {
        return;
    }
    DataTable dt = new DataTable();
    DataRow dr;
    dt.Columns.Add("Test");
    dr = dt.NewRow();
    dr[0] = 1;
    dt.Rows.Add(dr);
    dr = dt.NewRow();
    dr[0] = 2;
    dt.Rows.Add(dr);
    dr = dt.NewRow();
    dr[0] = 3;
    dt.Rows.Add(dr);
    FpSpread1.Sheets[0].DataSource = dt;
    FarPoint.Web.Spread.StyleInfo si = new FarPoint.Web.Spread.StyleInfo("DataAreaDefault");
    si.Formatter = new myf();
    FpSpread1.ActiveSheetView.DefaultStyle = si;
    bool b;
    b = si.IsPropertySet(FarPoint.Web.Spread.SheetStyleProperty.Formatter);
    if (b)
    {
        Response.Write("The formatter has been set.");
    }
<Serializable()> 
Public Class myf
Implements FarPoint.Web.Spread.Renderer.IFormatter

Public Function Format(ByVal o As Object) As String Implements FarPoint.Web.Spread.Renderer.IFormatter.Format
Select Case o
Case 1
Return "Test1"
Case 2
Return "Test2"
Case 3
Return "Test3"
End Select
End Function

Public Function Parse(ByVal s As String) As Object Implements FarPoint.Web.Spread.Renderer.IFormatter.Parse
Select Case s
Case "Test1"
Return 1
Case "Test2"
Return 2
Case "Test3"
Return 3
End Select
End Function
End Class

If IsPostBack Then Return
Dim dt As New DataTable
Dim dr As DataRow
dt.Columns.Add("Test")
dr = dt.NewRow
dr.Item(0) = 1
dt.Rows.Add(dr)
dr = dt.NewRow
dr.Item(0) = 2
dt.Rows.Add(dr)
dr = dt.NewRow
dr.Item(0) = 3
dt.Rows.Add(dr)
FpSpread1.Sheets(0).DataSource = dt
Dim s As FarPoint.Web.Spread.SheetStyleProperty
Dim si As New FarPoint.Web.Spread.StyleInfo("DataAreaDefault")
si.Formatter = New myf
FpSpread1.ActiveSheetView.DefaultStyle = si
Dim b As Boolean
b = si.IsPropertySet(s.Formatter)
If b Then
Response.Write("The formatter has been set.")
End If
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

SheetStyleProperty Class
SheetStyleProperty Members

 

 


Copyright © GrapeCity, inc. All rights reserved.