Apply culture formatting in grid

[Frans]

Hi,

I would like to format date columns and decimal number columns in the correct format, according to the logged in users' culture.
I found examples / code snippets of that, but those didnt work. Maybe because a clientside culture variable was needed but not present or so. or maybe because the formats were not supported I dont know.

Anyway, how can I achieve culture formatting in the grid ?

Preferably in a simple serverside way. And also preferably not on application level (by setting application culture), but controller level, or just custom formatting myself serverside, without setting the culture on application level.

For example, I live in the Netherlands, where the date format is: dd-MM-yyyy, and the decimal number format N2, or e.g.: 2.500.000,95

I have the culture of the logged in user both serverside as clientside in a variable.

 

Martin

 

[Tsvetomir]

Hi Martin,

When the application should run culture-specific formats, then you should set the culture of the client-side as shown in the following resources:

• https://docs.telerik.com/aspnet-mvc/globalization/overview
• https://demos.telerik.com/aspnet-mvc/grid/globalization

After the culture scripts are loaded and the option is set up, you could apply custom formatting for some of the columns:

 

.Format("{0: n2}")

 

This way, the Kendo UI Grid will apply a number format with two decimals after the decimal separator and it will be culture-specific.

Give this suggestion a try and let me know how it works out for you.

 

Regards,
Tsvetomir
Progress Telerik