GeneralFormatter Constructor()

Creates a new default general formatter.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New()

'Usage
 
Dim instance As New GeneralFormatter()

public GeneralFormatter()

Example

This example sets several different formatters.

double dvalue = 12345.6789;       
gcSpreadSheet1.Sheets[0].Cells[0, 0].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.StandardNumericMode, "c");
gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = dvalue;
gcSpreadSheet1.Sheets[0].Cells[0, 1].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.StandardDateTimeMode, "M");
gcSpreadSheet1.Sheets[0].SetValue(0, 1, new DateTime(2011, 2, 9));
gcSpreadSheet1.Sheets[0].Cells[0, 2].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter("m");
gcSpreadSheet1.Sheets[0].SetValue(0, 2, new DateTime(2012, 10, 15));
gcSpreadSheet1.Sheets[0].Cells[0, 3].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter();
gcSpreadSheet1.Sheets[0].SetValue(0, 3, new DateTime(2012, 10, 15));
gcSpreadSheet1.Sheets[0].Cells[0, 4].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.CustomMode, "#.#%");
gcSpreadSheet1.Sheets[0].SetValue(0, 4, 1);
gcSpreadSheet1.Sheets[0].Cells[1, 0].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.CustomMode, "[>2]0.0;[<-3]0.0;zero;");
gcSpreadSheet1.Sheets[0].SetValue(1, 0, 3);
gcSpreadSheet1.Sheets[0].Cells[2, 0].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.CustomMode, "[Red](#,##0.00)");
gcSpreadSheet1.Sheets[0].SetValue(2, 0, 3);
gcSpreadSheet1.Sheets[0].Cells[3, 0].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.CustomMode, @"(#.##)\[;-#.##\]\[;0.0\]\[;zero\]");
gcSpreadSheet1.Sheets[0].SetValue(3, 0, 3);
gcSpreadSheet1.Invalidate();

VB.NET

Dim dvalue As Double
dvalue = 12345.6789
GcSpreadSheet1.Sheets(0).Cells(0, 0).Formatter = New GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.StandardNumericMode, "c")
GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = dvalue
GcSpreadSheet1.Sheets(0).Cells(0, 1).Formatter = New GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.StandardDateTimeMode, "M")
GcSpreadSheet1.Sheets(0).SetValue(0, 1, New DateTime(2011, 2, 9))
GcSpreadSheet1.Sheets(0).Cells(0, 2).Formatter = New GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter("m")
GcSpreadSheet1.Sheets(0).SetValue(0, 2, New DateTime(2012, 10, 15))
GcSpreadSheet1.Sheets(0).Cells(0, 3).Formatter = New GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter()
GcSpreadSheet1.Sheets(0).SetValue(0, 3, New DateTime(2012, 10, 15))
GcSpreadSheet1.Sheets(0).Cells(0, 4).Formatter = New GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.CustomMode, "#.#%")
GcSpreadSheet1.Sheets(0).SetValue(0, 4, 1)
GcSpreadSheet1.Sheets(0).Cells(1, 0).Formatter = New GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.CustomMode, "[>2]0.0;[<-3]0.0;zero;")
GcSpreadSheet1.Sheets(0).SetValue(1, 0, 3)
gcSpreadSheet1.Sheets(0).Cells(2, 0).Formatter = New GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.CustomMode, "[Red](#,##0.00)")
gcSpreadSheet1.Sheets(0).SetValue(2, 0, 3)
gcSpreadSheet1.Sheets(0).Cells(3, 0).Formatter = New GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.CustomMode, "(#.##)\[;-#.##\]\[;0.0\]\[;zero\]")
gcSpreadSheet1.Sheets(0).SetValue(3, 0, 3)
GcSpreadSheet1.Invalidate()

Requirements

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

Reference

GeneralFormatter Class
GeneralFormatter Members
Overload List