Formatting Cells

You can format cell values using standard number, date time, and custom formats.

Numbers are formatted based on the current culture. The default culture is English.

The custom format mode supports the combo, conditional, and forecolor formatters. The "(", ")", and "*" expressions are not supported.

Use the Formatter property to specify the format in code.

Using Code

The following example formats cell values with different types of formats.

CS	Copy Code
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.Invalidate();

Copy Code

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.Invalidate();

VB.NET	Copy Code
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.Invalidate()

VB.NET

Copy Code

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.Invalidate()