Localizing functions

You can localize a function's ID and error messages. Currently, the library supports 16 languages with English as the default.

To change the default language all you need to do is to 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 a string. They follow a naming convention that incorporates two standards: ISO-639 and ISO-3166-1. The pattern is languageCOUNTRY, for example nbNO, frFR, enGB 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 translate your own custom functions into different languages too. You need to define the translations and register the corresponding language pack after registering a plugin:

const translations = {
    'enGB': {
      'HYPER': 'HYPER'
    },
    'plPL': {
      'HYPER': 'HAJPER'
    }
  }

List of supported languages

Language name	Language code
English	enGB
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

Demo