# Localizing functions
You can localize a function's ID and error messages. Currently, HyperFormula supports 17 languages, with British English as the default.
To change the language all you need to do is import and register the language like so:
// import the French language pack
import frFR from 'hyperformula/es/i18n/languages/frFR';
// register the language
HyperFormula.registerLanguage('frFR', frFR);
TIP
To import the language packs, use the module-system-specific dedicated bundles at:
- ES:
hyperformula/es/i18n/languages/ - CommonJS:
hyperformula/commonjs/i18n/languages/ - UMD:
hyperformula/dist/languages/
For the UMD build, the languages are accessible through HyperFormula.languages, e.g., HyperFormula.languages.frFR.
Then set it inside it the configuration options:
// configure the instance
const options = {
language: 'frFR'
};
Language pack names should be passed as strings. They follow a
naming convention that incorporates two standards: ISO-639 and
ISO-3166-1. The pattern is languageCOUNTRY, for
example enUS, enGB, frFR, etc.
You can freely use the localized names: SUM can be written as
SOMME and the functionality of the function will remain the same.
Here are some example functions and their translations in French:
// localized functions
functions: {
MATCH: 'EQUIV',
CORREL: 'COEFFICIENT.CORRELATION',
AVERAGE: 'MOYENNE'
},
Same goes for the errors displayed inside cells when something goes wrong:
// localized errors
errors: {
CYCLE: '#CYCLE!',
DIV_BY_ZERO: '#DIV/0!',
ERROR: '#ERROR!',
NA: '#N/A',
NAME: '#NOM?',
NUM: '#NOMBRE!',
REF: '#REF!',
VALUE: '#VALEUR!',
}
# Localizing custom functions
You can localize your custom functions as well. For details, see the Custom functions guide.
# List of supported languages
| Language name | Language code |
|---|---|
| British English | enGB |
| American English | enUS |
| Czech | csCZ |
| Danish | daDK |
| Dutch | nlNL |
| Finnish | fiFI |
| French | frFR |
| German | deDE |
| Hungarian | huHU |
| Italian | itIT |
| Norwegian | nbNO |
| Polish | plPL |
| Portuguese | ptPT |
| Russian | ruRU |
| Spanish | esES |
| Swedish | svSE |
| Turkish | trTR |