FormatString doesn't work

[Ales]

Hi All,

a have this procedure :

foreach (GridViewDataColumn dataColumn in radGridBatches.Columns)
 {
      dataColumn.TextAlignment = ContentAlignment.BottomRight;
      dataColumn.FormatString = "{0:F2}";
}

but the number in Grid are 600
                                           592.35
                                          600
                                           etc...
need somebody help ?

lot thanks Alda

PROBLEM SOLVED, DOUBLE CONVERTED TO DECIMAL

[Ivan Petrov]

Hello Alda,

Thank you for writing.

In order to make this format string to work, you have to apply it to a GridViewDecimalColumn. If you are setting it to a GridViewTextBoxColumn, it will not work. If this is not your case, I would kindly ask you to provide some more details on your case and grid setup. 

I am looking forward to you reply.

Kind regards,
Ivan Petrov
the Telerik team

[Ryan]

Then why have a FormatString property for GridViewTextBoxColumn if it isn't useable?

[Dess | Tech Support Engineer, Principal]

Hello, Ryan,

The FormatString property is inherited by the basic class GridViewDataColumn that is common for all column types. But this property is not respected by all column types, e.g. GridViewTextBoxColumn. Numerical data is usually appropriate to be handled by a GridViewDecimalColumn or a GridViewMaskBoxColumn  with the appropriate numeric mask.

I hope this information helps.