1. Home
  2. Forum
  3. Vue
  4. Speadsheet globalization - setCurrencyCode conflict with component language

Speadsheet globalization - setCurrencyCode conflict with component language

Hello,

I'm trying to set the culture and currency to French and Euro respectively. 

I manually fetched the different JSON files needed and loaded them like so :

import { L10n, setCulture, setCurrencyCode, loadCldr } from '@syncfusion/ej2-base';

loadCldr(require('./syncfusionL10n/currencies.json'),
require('./syncfusionL10n/numbers.json'),
require('./syncfusionL10n/ca-gregorian.json'),
require('./syncfusionL10n/timeZoneNames.json'));

setCulture('fr');
setCurrencyCode('EUR')

The first thing I observed is that the component is using the JSON config currencies.json because the format of cell in dollar changed, but it is not using Euro. I double checked and it's present in the config file.

The second thing I did was to change the label of the component to French like so :

L10n.load({
'fr':{
"spreadsheet": {
"Insert": "Insérer",
"Delete": "Supprimer",
...
"General": "Général",
"Number": "Nombre",
"Currency": "devise",
"Accounting": "Comptabilité",
"ShortDate": "Date courte",
"LongDate": "Date longue",
"Time": "Temps",
"Percentage": "Pourcentage",
"Fraction": "Fraction",
"Scientific": "Scientifique",
"Text": "Texte",
...
}
}
});

When changing the label language for Number, Currency, Accounting, ..., the format of the cell break : 

https://imgur.com/a/HkR9amd

I also saw that the spreadsheet component has a "locale" property but it doesn't appear to work, maybe I'm missing a depedency?
https://ej2.syncfusion.com/vue/documentation/api/spreadsheet/#locale

My question is, what is the correct way to globalize the Vue Spreadsheet component to French and Euro?

Thanks,,
Tuan

5 Replies 1 reply marked as answer
TA Tuan Ardouin March 26, 2021 02:06 PM UTC

Should I create a ticket for this ?

SP Sangeetha Priya Murugan Syncfusion Team March 31, 2021 12:24 PM UTC

Hi Tuan Ardouin, 
 
Thank you for contacting Syncfusion support. 
 
We have checked your reported issue and we confirmed this as defect and the fix will be available in our April 28th weekly patch release, we appreciate your patience until then. You can track the status of this defects using below link from our feedback portal,  
 
 
Regards, 
Sangeetha M 


SP Sangeetha Priya Murugan Syncfusion Team May 3, 2021 12:21 PM UTC

Hi Tuan 
 
Thank you for your patience. 
 
We are glad to announce that our weekly patch release (19.1.58) is rolled out. We have included the fix for the reported issue in this release. So, we suggest you upgrade our Syncfusion NPM Spreadsheet package to our latest version to resolve this issue in your end.   
 
 
Regards, 
Sangeetha M 


TA Tuan Ardouin May 28, 2021 08:21 AM UTC

Hello,

Thank you for this update. However, is doesn't seem to work, now the whole component is not being translated.

Could you show me the definitive and final way to have the spreadsheet component in French and in euros please ?

Right now I'm doing : 

import {
L10n,
setCulture,
setCurrencyCode,
loadCldr
} from '@syncfusion/ej2-base'

loadCldr(
require('./syncfusionL10n/currencies.json'),
require('./syncfusionL10n/numbers.json'),
require('./syncfusionL10n/ca-gregorian.json'),
require('./syncfusionL10n/timeZoneNames.json'),
require('./syncfusionL10n/numberingSystems.json')
)

import * as currencies from './syncfusionL10n/currencies.json'
import * as numbers from './syncfusionL10n/numbers.json'
import * as ca from './syncfusionL10n/ca-gregorian.json'
import * as timeZoneNames from './syncfusionL10n/timeZoneNames.json'
import * as numberingSystems from './syncfusionL10n/numberingSystems.json'

loadCldr(currencies, numbers, ca, timeZoneNames, numberingSystems)

Vue.use(SpreadsheetPlugin)

setCulture('fr')
setCurrencyCode('EUR')

L10n.load({
fr: {
spreadsheet: {
InsertingEmptyValue: "La valeur de référence n'est pas valide.",
FindValue: 'Trouver de la valeur',

Is this wrong ?

Thank you,
Tuan

SP Sangeetha Priya Murugan Syncfusion Team May 31, 2021 06:26 AM UTC

Hi Tuan, 
 
Thank you for your update. 
 
We have checked your reported issue and the date and currency format applied properly for French culture in our latest version. We suspect that you haven’t properly refer the cldr-data package files in your application. For your convenience, we have prepared the sample based on your requirement. Please find the link below. 
 
 
For more details, regarding the globalization. Please refer the below link. 
 
 
 
Could you please check the above link and ensure whether you have properly referred the cldr-data package files in your application. And kindly get back to us, if you still need any further assistance on this. 
 
Regards, 
Sangeetha M 


Marked as answer
Loader.
Up arrow icon