C# – DataGridView Format Decimal Values with AutoGenerateColumns

cdatagridviewdecimal-pointwinforms

I have a datagridview that uses AutoGenerateColumns in winforms. There is a date column and then 1-16 data columns containing numeric values. I want all of these 1-16 data columns to be formatted to 4 decimal places.

As per this post, you set the DefaultCellStyle through the designer. I did this manually to get what format that I want to use. I set this in the form constructor:

this.dgv_PreviewGrid.DefaultCellStyle.Format = "N4";

I have tried setting it this way and also tried manually on each column on DataBindingComplete event. Nothing happens! The app lags as though it is doing the rounding, but doesn't.

Also, is there a link to msdn or something with a list of the DefaultCellStyle formats? Couldn't find them.

EDIT: I found that using Format "D4" instead of "N4" (Decimal vs. Number) –> is probably the format that I want, but it is still not working.

Best Answer

The MSDN page you want is Standard Numeric Format Strings.

You want the N or F format specifier, not D. D is for integers.

Setting grid.DefaultCellStyle.Format should work, but since you have a date column you will need to override that column's DefaultCellStyle, or the dates won't display.

What is the actual type of the numeric property on your datasource? Are you sure it isn't a string? How are you populating the DataGridView?

Without more information it's difficult to guess the problem. It might help if you show the code that populates the DataGridView.

Related Solutions

C# – How to automatically resize columns in a DataGridView control AND allow the user to resize the columns on that same grid

This trick works for me:

    grd.DataSource = DT;

    // Set your desired AutoSize Mode:
    grd.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
    grd.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
    grd.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;

    // Now that DataGridView has calculated it's Widths; we can now store each column Width values.
    for (int i = 0; i <= grd.Columns.Count - 1; i++)
    {
        // Store Auto Sized Widths:
        int colw = grd.Columns[i].Width;

        // Remove AutoSizing:
        grd.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;

        // Set Width to calculated AutoSize value:
        grd.Columns[i].Width = colw;
    }

In the Code above: You set the Columns AutoSize Property to whathever AutoSizeMode you need. Then (Column by Column) you store each column Width value (from AutoSize value); Disable the AutoSize Property and finally, set the Column Width to the Width value you previously stored.

C# Double – ToString() formatting with two decimal places but no rounding

I use the following:

double x = Math.Truncate(myDoubleValue * 100) / 100;

For instance:

If the number is 50.947563 and you use the following, the following will happen:

- Math.Truncate(50.947563 * 100) / 100;
- Math.Truncate(5094.7563) / 100;
- 5094 / 100
- 50.94

And there's your answer truncated, now to format the string simply do the following:

string s = string.Format("{0:N2}%", x); // No fear of rounding and takes the default number format

Best Answer

Related Solutions

C# – How to automatically resize columns in a DataGridView control AND allow the user to resize the columns on that same grid

C# Double – ToString() formatting with two decimal places but no rounding

Related Topic