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

This example sets the Formatter property for the cell.

CS	Copy Code
double dvalue = 12345.6789; gcSpreadSheet1.Sheets[0].Cells[0, 0].Formatter = new GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter(GrapeCity.Xaml.SpreadSheet.Data.FormatMode.StandardNumericMode, "c"); gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = dvalue; gcSpreadSheet1.Sheets[0].Cells[0, 1].Formatter = new GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter(GrapeCity.Xaml.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.Xaml.SpreadSheet.Data.GeneralFormatter("m"); gcSpreadSheet1.Sheets[0].SetValue(0, 2, new DateTime(2012, 10, 15)); gcSpreadSheet1.Sheets[0].Cells[0, 3].Formatter = new GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter(); gcSpreadSheet1.Sheets[0].SetValue(0, 3, new DateTime(2012, 10, 15)); gcSpreadSheet1.Sheets[0].Cells[0, 4].Formatter = new GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter(GrapeCity.Xaml.SpreadSheet.Data.FormatMode.CustomMode, "#.#%"); gcSpreadSheet1.Sheets[0].SetValue(0, 4, 1); gcSpreadSheet1.Sheets[0].Cells[1, 0].Formatter = new GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter(GrapeCity.Xaml.SpreadSheet.Data.FormatMode.CustomMode, "[>2]0.0;[<-3]0.0;zero;"); gcSpreadSheet1.Sheets[0].SetValue(1, 0, 3);

Copy Code

double dvalue = 12345.6789; 
gcSpreadSheet1.Sheets[0].Cells[0, 0].Formatter = new GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter(GrapeCity.Xaml.SpreadSheet.Data.FormatMode.StandardNumericMode, "c");
gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = dvalue;
gcSpreadSheet1.Sheets[0].Cells[0, 1].Formatter = new GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter(GrapeCity.Xaml.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.Xaml.SpreadSheet.Data.GeneralFormatter("m");
gcSpreadSheet1.Sheets[0].SetValue(0, 2, new DateTime(2012, 10, 15));
gcSpreadSheet1.Sheets[0].Cells[0, 3].Formatter = new GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter();
gcSpreadSheet1.Sheets[0].SetValue(0, 3, new DateTime(2012, 10, 15));
gcSpreadSheet1.Sheets[0].Cells[0, 4].Formatter = new GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter(GrapeCity.Xaml.SpreadSheet.Data.FormatMode.CustomMode, "#.#%");
gcSpreadSheet1.Sheets[0].SetValue(0, 4, 1);
gcSpreadSheet1.Sheets[0].Cells[1, 0].Formatter = new GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter(GrapeCity.Xaml.SpreadSheet.Data.FormatMode.CustomMode, "[>2]0.0;[<-3]0.0;zero;");
gcSpreadSheet1.Sheets[0].SetValue(1, 0, 3);

VB	Copy Code
Dim dvalue As Double dvalue = 12345.6789 GcSpreadSheet1.Sheets(0).Cells(0, 0).Formatter = New GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter(GrapeCity.Xaml.SpreadSheet.Data.FormatMode.StandardNumericMode, "c") GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = dvalue GcSpreadSheet1.Sheets(0).Cells(0, 1).Formatter = New GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter(GrapeCity.Xaml.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.Xaml.SpreadSheet.Data.GeneralFormatter("m") GcSpreadSheet1.Sheets(0).SetValue(0, 2, New DateTime(2012, 10, 15)) GcSpreadSheet1.Sheets(0).Cells(0, 3).Formatter = New GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter() GcSpreadSheet1.Sheets(0).SetValue(0, 3, New DateTime(2012, 10, 15)) GcSpreadSheet1.Sheets(0).Cells(0, 4).Formatter = New GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter(GrapeCity.Xaml.SpreadSheet.Data.FormatMode.CustomMode, "#.#%") GcSpreadSheet1.Sheets(0).SetValue(0, 4, 1) GcSpreadSheet1.Sheets(0).Cells(1, 0).Formatter = New GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter(GrapeCity.Xaml.SpreadSheet.Data.FormatMode.CustomMode, "[>2]0.0;[<-3]0.0;zero;") GcSpreadSheet1.Sheets(0).SetValue(1, 0, 3)

Copy Code

Dim dvalue As Double
dvalue = 12345.6789
GcSpreadSheet1.Sheets(0).Cells(0, 0).Formatter = New GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter(GrapeCity.Xaml.SpreadSheet.Data.FormatMode.StandardNumericMode, "c")
GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = dvalue
GcSpreadSheet1.Sheets(0).Cells(0, 1).Formatter = New GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter(GrapeCity.Xaml.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.Xaml.SpreadSheet.Data.GeneralFormatter("m")
GcSpreadSheet1.Sheets(0).SetValue(0, 2, New DateTime(2012, 10, 15))
GcSpreadSheet1.Sheets(0).Cells(0, 3).Formatter = New GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter()
GcSpreadSheet1.Sheets(0).SetValue(0, 3, New DateTime(2012, 10, 15))
GcSpreadSheet1.Sheets(0).Cells(0, 4).Formatter = New GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter(GrapeCity.Xaml.SpreadSheet.Data.FormatMode.CustomMode, "#.#%")
GcSpreadSheet1.Sheets(0).SetValue(0, 4, 1)
GcSpreadSheet1.Sheets(0).Cells(1, 0).Formatter = New GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter(GrapeCity.Xaml.SpreadSheet.Data.FormatMode.CustomMode, "[>2]0.0;[<-3]0.0;zero;")
GcSpreadSheet1.Sheets(0).SetValue(1, 0, 3)