Number column no format incorrect display on globalization

[Dan]

I have a grid with 2 numeric columns. One of the column has to have a maximum of 5 decimals while the other should display all the decimals it has. The configuration is like this:

columns.Bound(m => m.Numeric1).Format("{0:#.#####}");
columns.Bound(m => m.Numeric2);

However when I tried to view the values in the culture "de-DE" for example for the first column it uses the correct decimal separator "," but for the second column it still display the decimal separator ".".

Is the format of numeric values mandatory when using i18n ? What is the format for numeric with all the decimals?

[Tsvetomir]

Hi Dan,

Thank you for the provided explanation of the scenario you are facing. 

In general, both the comma and the dot are valid symbols in the German culture. Since the data that comes from the server would have the dot separator, it is interpreted as a valid symbol and is used as-is. What I can recommend is that you explicitly set the format to be number. Here is an example:

                    columns.Bound(p => p.Freight).Format("{0:#.#####}");
                    columns.Bound(p => p.OrderID).Format("{0:n}");

Also, it is important to point out that there is no built-in rule that could be used for rendering all of the decimals after the separator. Therefore, you would have to implement the Format with a sufficient number of "#" symbols.

Give the suggestion a try and let me know in case 

 

Regards,
Tsvetomir
Progress Telerik