Spread Silverlight Documentation > Developer's Guide > Managing Data > 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.
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(); |
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() |