Spread WPF 14
Spread WPF Documentation / Developer's Guide / Managing Data / Formatting Cells
In This Topic
    Formatting Cells
    In This Topic

    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();
    
    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()
    
    See Also