Localizing DataTable

DataTable provides support for localizing numbers, currencies, and dates.

The standard package of the Webix library includes 9 locales:

  • "en-US" - North American (used by default);
  • "ru-RU" - Russian;
  • "fr-FR" - French;
  • "ja-JP" - Japanese;
  • "be-BY" - Belarusian;
  • "de-DE" - German;
  • "es-ES" - Spanish;
  • "it-IT" - Italian;
  • "zh-CN" - Chinese.

Webix Pro edition includes over 300 locales.

To localize your app into some other language, do the following:

  1. Create a locale file.
  2. Activate the locale.

Creating Locales

Locale is created in a separate js file named as "ll-CC", where:

  • ll - a two-letter language code;
  • CC - a two-letter country code.

Creating Spanish (Spain) locale for DataTable. The 'es-ES.js' file

webix.i18n.locales["es-ES"]={  // "es-ES" - the locale name, the same as the file name
  groupDelimiter:" ",     // a mark that divides numbers with many digits into groups
  groupSize:3,            // the number of digits in a group
  decimalDelimiter:",",   // the decimal delimiter
  decimalSize:2,          // the number of digits after the decimal mark
 
  // applied to columns with 'format:webix.i18n.dateFormatStr'
  dateFormat:"%d/%m/%Y",
  // applied to columns with 'format:webix.i18n.dateFormatStr'
  timeFormat:"%H:%i",
  // applied to columns with 'format:webix.i18n.longDateFormatStr'
  longDateFormat:"%d %F %Y",
  // applied to cols with 'format:webix.i18n.fullDateFormatStr'
  fullDateFormat:"%d.%m.%Y %H:%i",
 
  // EUR-currency name.Applied to cols with 'format:webix.i18n.priceFormat'
  price:"{obj} EUR",
  calendar:{
    monthFull:["Enero", "Febrero", "Marzo", "Abril", "Mayo", "Junio",
        "Julio", "Agosto", "Septiembre", "Octubre", "Noviembre", "Diciembre"],
    monthShort:["En", "Feb", "Mar", "Abr", "Mayo", "Jun",
        "Jul", "Ago", "Sep", "Oct", "Nov", "Dic"],
    dayFull:["Domingo", "Lunes", "Martes", "Miercoles", "Jueves", "Viernes", "Sabado"],
    dayShort:["Dom", "Lun", "Mar", "Mier", "Jue", "Vier", "Sab"]
  }
};
  • monthFull - the full names of months starting from January;
  • monthShort - the short names of months starting from January;
  • dayFull - the full names of week days starting from Sunday;
  • dayShort - the short names of week days starting from Sunday.

Activating Locale

To activate a locale:

  1. Include the related locale file on the page;
  2. Call webix.i18n.setLocale('locale_name') ( !before DataTable initialization).
<script src="../locale/es-ES.js" type="text/javascript" charset="utf-8"></script>
 
<script>
    webix.i18n.setLocale("es-ES");
    grid = webix.ui({
        view:"datatable",
        columns:[
            { header:"Date",  id:"start", format:webix.i18n.dateFormatStr},
            { header:"LongDate",width:170, id:"start",format:webix.i18n.longDateFormatStr},
            { header:"Price",  id:"number", format:webix.i18n.priceFormat },
        ],
        ...
    });
</script>

Related sample:  DataTable Localization

Back to top
Join Our Forum
We've retired comments here. Visit our forum for faster technical support, connect with other developers, and share your feedback there.
If you have not checked yet, be sure to visit site of our main product Webix html5 ui library and page of web datagrid product.