We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Localization Settings to UK

Thread ID:

Created:

Updated:

Platform:

Replies:

130752 May 31,2017 04:17 AM Jun 15,2017 12:54 AM ASP.NET MVC 13
loading
Tags: Grid
Frankie Moran
Asked On May 31, 2017 04:17 AM

Good morning, 

I have an issue with the Localization. I have set ".Locale('en-gb')" on the view and also changed the _Layout.cshtml to look at the Script "~/Scripts/lang/uk.js" but the Grid is still showing the date in an American format i.e. mm/dd/yyyy whereas I need it in dd/mm/yyyy. I have a work around on the grid for that column, however, when grouping on the date column it shows it in this format like in the photograph below: 



Are you able to help me on this issue? 

Much appreciated 

Thanks,
Frankie

Saravanan Arunachalam [Syncfusion]
Replied On June 1, 2017 09:01 AM

Hi Frankie, 
Thanks for contacting Syncfusion’s support. 
By default, the value in the groupcaption is formatted based on the specified format on that grouped column, i.e if you specified the DueDate column format as {0: mm/dd/yyyy}, group caption value will format based on this specific format which is behavior of Grid grouping. 
So, we suggest you to specify the required format in the Grid columns object itself and please refer to the below code example. 
    
@(Html.EJ().Grid<EditableOrder>("Grouping") 
        . . . 
        .Columns(col => 
        { 
            . . . 
            col.Field("OrderDate").HeaderText("Order Date").TextAlign(TextAlign.Right).Format("{0:dd/MM/yyyy hh:mm:ss}").Width(90).Add(); 
        }) 
    ) 
 
Regards, 
Saravanan A. 


Frankie Moran
Replied On June 1, 2017 10:23 AM

Hi Saravanan,

Thank you for your help that has helped and fixed the issue. 

One quick one related to another project we are currently working on. We have a summary field which calculates all the values, however, it is showing as dollars and we need it in pounds. I'm going to guess its a similar situation where you need to format the column with {{0:£}}? 

Many thanks,
Frankie

Saravanan Arunachalam [Syncfusion]
Replied On June 2, 2017 01:05 AM

Hi Frankie, 
We suspect that you have missed to set the currency format in both the Grid’s Columns and SummaryColumns property. So, please ensure whether you have set the currency format for both Columns and SummaryColumns that refer from the below code example and online demo link. 
@(Html.EJ().Grid<OrdersView>("Summary") 
          . . . 
          .SummaryRow(row => 
          { 
              row.ShowTotalSummary(false) 
                 .SummaryColumns(col => 
                 { 
                     col.SummaryType(SummaryType.Sum) 
                        .DisplayColumn("Freight") 
                        .DataMember("Freight") 
                        .Prefix("Average = ") 
                        .Format("{0:C}") 
                        .Add(); 
                      
                 }).Add(); 
          }) 
          .Locale("en-GB") 
          .Columns(col => 
          { 
            . . .              col.Field("Freight").HeaderText("Freight").TextAlign(TextAlign.Right).Width(80).Format("{0:C}").Add(); 
          }) 
) 
 
 
 We have created a sample that can be downloaded from the below link. 
Regards, 
Saravanan A. 


Frankie Moran
Replied On June 2, 2017 04:24 AM

Hi Saravanan,

Thank you for that. 

Going back to the issue about the date format being: MM/DD/YYYY hh:mm:ss this is fixed on screen, however, whenever the grid is exported with the grouping of the due date column it still has the format MM/DD/YYYY hh:mm:ss. 

How do you solve this issue on the exported files?

Thanks,
Frankie

Saravanan Arunachalam [Syncfusion]
Replied On June 5, 2017 02:40 AM

Hi Frankie, 
We are sorry that we are unable to reproduce the reported issue and we have created a sample for your requirement that can be downloaded from the below link, 
For your reference, we have attached the exported document that can be download from the below link. 
And please refer to the below links to know more about exporting. 
If the issue is still exist, could you please provide the below details? 
1.       Share your build version. 
2.       Share your view code and its controller code. 
3.       If possible, please reproduce the issue in the above sample. 
Regards, 
Saravanan A. 


Frankie Moran
Replied On June 8, 2017 04:06 AM

Good morning Saravanan,

I have fixed the date issue which now shows in the format: dd/MM/yyyy. Thank you for that. 

I am still having issues around the currency issue. It still shows as '$' when it should show as '£' and I have also noticed that negative numbers show as ($15.70) rather than -£15.70. I have placed the .Loacle("en-GB") and on the the column ensured it has the currency format. 

"col.Field("UnitPrice").AllowFiltering(false).HeaderText("Unit Price").TextAlign(TextAlign.Right).Format("{0:C2}").Width("10%").Add();"

Can you please advise? 

Thanks,
Frankie

Saravanan Arunachalam [Syncfusion]
Replied On June 9, 2017 05:07 AM

Hi Frankie, 
We are sorry that we are unable to reproduce the reported issue and we suspect that you have not load the corressponding culture in script reference. So, please ensure whether you have referred the specified culture script file in the layout page. Please refer to the below code example and online documentation link. 
<html lang="en"> 
    <head> 
        <meta charset="utf-8" /> 
        <title>@ViewBag.Title - My ASP.NET MVC Application</title> 
        <meta name="viewport" content="width=device-width" />                 
        <link rel='nofollow' href="~/Content/ej/web/default-theme/ej.web.all.min.css" rel="stylesheet" /> 
        @Scripts.Render("~/bundles/modernizr") 
        @Scripts.Render("~/Scripts/jquery-2.1.4.min.js") 
        @Scripts.Render("~/Scripts/jsrender.min.js") 
        <script src="~/Scripts/jsondata.min.js"></script> 
        <script src="~/Scripts/ej/ej.web.all.min.js"></script> 
        @*Load the cultures*@ 
        <script src="~/Scripts/ej/i18n/ej.culture.en-GB.min.js"></script> 
 
</head> 
 
Regards, 
Saravanan A. 


Frankie Moran
Replied On June 12, 2017 06:43 AM

Hi Saravanan,
 
I have just looked in the C:/ drive of where my SyncFusion is installed and the "ej.culture.en-GB.min.js" you refer to is not in the folder at all. I cannot find it at all.

Where are you able to find this file so I am able to refer to it? 

Thanks,
Frankie

Saravanan Arunachalam [Syncfusion]
Replied On June 13, 2017 01:21 AM

Hi Frankie, 
You can get the culture-specific script files either from installed location or from github location and we have already discussed this query in the following user guide documentation link. 
Regards, 
Saravanan A. 


Frankie Moran
Replied On June 13, 2017 03:39 AM

Hi Saravanan,

I seem to be missing this file from the install of SyncFusion. However, I will try GitHub and get back to you to see if it works or not! 

Thanks,
Frankie



Saravanan Arunachalam [Syncfusion]
Replied On June 14, 2017 02:41 AM

Hi Frankie, 
To translate our control content from default English to any of the culture, say For example - UK language, then you need to refer the ej.culture.en-GB.min.js and ej.localetexts.de-DE.min.js files in your application, after the reference of ej.web.all.min.js file.
Note: Seven culture-specific script and its localetext files are available in the build installed location. For all other culture files, please download from the below locations.
 
Regards, 
Saravanan A. 


Frankie Moran
Replied On June 14, 2017 06:45 AM

Hi Saravanan,

That worked!

Thanks,
Frankie

Saravanan Arunachalam [Syncfusion]
Replied On June 15, 2017 12:54 AM

Hi Frankie,  
Thanks for your update.       
We are happy that the provided information helped you. 
Regards, 
Saravanan A. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;