Spread WPF Documentation
Formatting the Database Column

You can format the values in the Unit Price column as currency values.

  1. Add the following CS or VB code to the project.
    CS Copy Code
    public MainPage()
    {
    InitializeComponent();
    GcSpreadSheet1.Sheets[0].Rows.Count = GcSpreadSheet1.Sheets[0].GetLastDirtyRow(GrapeCity.Windows.SpreadSheet.Data.StorageType.Data) + 1;
    GcSpreadSheet1.Sheets[0].Columns.Count = GcSpreadSheet1.Sheets[0].GetLastDirtyColumn(GrapeCity.Windows.SpreadSheet.Data.StorageType.Data) + 1;
    GcSpreadSheet1.Sheets[0].Cells[1, 4, 77, 4].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.StandardNumericMode, "c");
    }
    VB.NET Copy Code
    Public Sub New()
    InitializeComponent()
    GcSpreadSheet1.Sheets(0).Rows.Count = GcSpreadSheet1.Sheets(0).GetLastDirtyRow(GrapeCity.Windows.SpreadSheet.Data.StorageType.Data) + 1
    GcSpreadSheet1.Sheets(0).Columns.Count = GcSpreadSheet1.Sheets(0).GetLastDirtyColumn(GrapeCity.Windows.SpreadSheet.Data.StorageType.Data) + 1
    GcSpreadSheet1.Sheets(0).Cells(1, 4, 77, 4).Formatter = New GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.StandardNumericMode, "c")
    End Sub
  2. Save the project.

  3. Run the project to see the currency values in the Unit Price column. 

  4. You have completed this tutorial.