Trying to set currency to UK Pounds

[Karl McGeough]

Hello, I have been trying to change the currency displayed in my grid view from '$' to '£'. Is there anyway of doing this?

[Thavasianand Sankaranarayanan]

Hi Karl, 

 

Greetings from Syncfusion. 

 

Query: I have been trying to change the currency displayed in my grid view from '$' to '£'. Is there anyway of doing this?  

 

We have validated your query and created a sample based on your requirement. For Internationalization and localization, you need to include cldr files into your application. You need to download cldr-data globally in any location by using below command. 

 

Command: 

npm install cldr-data 

 

After installing cldr-data, you can find cldr-data for all locale in this location(node_modules->cldr-data->main). You need to copy the required(or all) locale cldr-data and paste into your application folder(Scripts->cldr->main->paste copied cldr files). 

 

You need to include cldr-data into your application and refer file location in index.cshtml file like below code example. Please find the below code example and sample for your reference. 

[code example] [index.cshtml] 

<div> 

    <ejs-grid id="Grid" locale="en-GB" dataSource="ViewBag.DataSource" allowPaging="true"> 

        <e-grid-pagesettings pageCount="4" pageSize="5"></e-grid-pagesettings> 

        <e-grid-columns> 

            <e-grid-column field="OrderID" headerText="Order ID" textAlign="Right" width="120"></e-grid-column> 

            <e-grid-column field="CustomerID" headerText="Customer Name" width="150"></e-grid-column> 

            <e-grid-column field="Freight" headerText="Freight" format="C2" width="120"></e-grid-column> 

            <e-grid-column field="OrderDate" headerText="Order Date" type="date" format="yMd" width="10%"></e-grid-column> 

            <e-grid-column field="ShipCountry" headerText="Ship Country" width="150"></e-grid-column> 

        </e-grid-columns> 

    </ejs-grid> 

</div> 

 

<script> 

 

 

    function loadCultureFiles(name) { 

        ej.base.setCulture(name); 

        ej.base.setCurrencyCode('GBP'); 

        var files = ['ca-gregorian.json', 'numbers.json','currencies.json', 'timeZoneNames.json']; 

        if (name === 'en-GB') { 

            files.push('numberingSystems.json'); 

        } 

        var loader = ej.base.loadCldr; 

        var loadCulture = function (prop) { 

            var val, ajax; 

            if (name === 'en-GB' && prop === files.length - 1) { 

                ajax = new ej.base.Ajax(location.origin + '/../../scripts/cldr-data/supplemental/' + files[prop], 'GET', false); 

            } else { 

                ajax = new ej.base.Ajax(location.origin + '/../../scripts/cldr-data/main/' + name + '/' + files[prop], 'GET', false); 

            } 

            ajax.onSuccess = function (value) { 

                val = value; 

            }; 

            ajax.send(); 

             

            loader(JSON.parse(val)); 

        }; 

        for (var prop = 0; prop < files.length; prop++) { 

            loadCulture(prop); 

        } 

    } 

 

    document.addEventListener('DOMContentLoaded', function () { 

        loadCultureFiles('en-GB'); 

    }); 

</script> 

Please find the sample in below link. 

Sample link: http://www.syncfusion.com/downloads/support/forum/142073/ze/TestSampleLocaleCore-1576190431_(2)-1795172692.zip 

Refer the help documentation. 

Link: https://ej2.syncfusion.com/aspnetcore/documentation/common/internationalization/?no-cache=1#setting-global-culture 

Link: https://ej2.syncfusion.com/aspnetcore/documentation/common/internationalization/?no-cache=1#setting-currency-code 

Link: https://ej2.syncfusion.com/javascript/documentation/api/grid#locale 

Please get back to us if you need further assistance. 

Regards, 

Thavasianand S.