You can easily localize SpreadSheet, by defining all the necessary language settings.
The SpreadSheet widget package includes only the en-US locale. Check our Locales repository for the language you need or create your own locale. Feel free to contribute your successful translation.
It's possible to localize the following properties:
The labels of SpreadSheet buttons, menu items and tooltips are stored in the webix.i18n.spreadsheet object:
export default {
labels:{
// formats
"common": "Common",
"currency": "Currency",
"number": "Number",
"percent": "Percent",
"date": "Date",
"string": "Text",
"custom-format": "Custom",
"decimal-places":"Decimal places",
"separator":"Group separator",
"negative":"Negative number",
"currency-symbol":"Сurrency",
"date-format":"Date format",
"format-docs":"How to create a format",
// titles
"undo-redo": "Undo/Redo",
"font": "Font",
"text": "Text",
"cell": "Cell",
"align": "Align",
"format": "Number",
"column": "Column",
"borders": "Borders",
"px": "px",
"apply": "Apply",
// popups and dialogs
"cancel": "Cancel",
"save": "Save",
// multisheets
"sheet": "Sheet",
// conditions
"conditional-format": "Conditional Format",
"condition": "Condition",
"conditional-style": "Style",
"conditional-operator": "Operator",
"conditional-between":"between",
"conditional-not-equal":"not equal",
// ranges
"range": "Range",
"range-title": "Named ranges",
"range-name": "Name",
"range-cells": "Range",
"range-scope": "Scope",
"range-global": "Book",
// images
"image-or": "or",
"image-title": "Add image",
"image-upload": "Select file for upload",
"image-url": "URL (e.g. http://*)",
// sparklines
"sparkline-title": "Add sparkline",
"sparkline-type": "Type",
"sparkline-range": "Range",
"sparkline-color": "Color",
"sparkline-positive": "Positive",
"sparkline-negative": "Negative",
// custom format
"format-title": "Set format",
"format-pattern": "Format pattern",
//dropdown
"dropdown-empty": "Empty cells",
"dropdown-title": "Add dropdown",
"dropdown-range": "Range",
// confirm
"ok": "OK",
// import/export
"import-title": "Import",
"import-not-support": "Sorry, your browser does not support import",
"export-title": "Export",
"export-name": "Name of xslx file",
"export-all-sheets":"Export all sheets",
// add link
"link-title": "Add Link",
"link-name": "Text",
"link-url": "URL",
//images
"image": "Image",
"add-image-cell":"Add to cell",
"add-image-top":"Add above cells",
//charts
"graph": "Graph",
"add-sparkline":"Add to cell",
"add-chart":"Add above cells",
//conditional format labels
"display" : "Display",
"value" : "Value",
// confirm messages
"range-remove-confirm":
"Are you sure you want to remove the range permanently?",
"sheet-remove-confirm":
"Are you sure you want to remove the sheet permanently?",
"merge-cell-confirm":
"Only the left top value will remain after merging. Continue?",
"error-range": "The range is incorrect!",
"error-link": "The link is incorrect!",
//print
"print":"Print",
"print-title":"Before you print..",
"print-settings":"General settings",
"print-paper":"Paper size",
"print-layout":"Layout",
"sheets":"Sheets:",
"selection":"Selected cells",
"borderless":"Hide gridlines",
"sheet-names":"Show sheet names",
"skip-rows":"Skip empty rows",
"margin":"Hide margins",
"page-letter":"Letter",
"page-a4":"A4 (210x297mm)",
"page-a3":"A3 (297x420mm)",
"page-width":"Page width",
"page-actual":"Actual Size",
"page-portrait":"Portrait",
"page-landscape":"Landscape",
"external-ui":"External UI",
"print-borders": "Show print borders",
//comment
"comment":"Comment",
//resize
"width":"Width",
"height":"Height",
"fit-content": "Fit to content",
"default-size":"Reset to default",
//views
"edit-view":"Edit",
"remove-view":"Remove",
"chart-edit":"Edit chart",
"chart-common":"Common",
"chart-series":"Series",
"chart-extras":"Extras",
"export-view":"Download",
"export-view-pdf":"PDF document",
"export-view-png":"PNG image",
"export-view-excel":"Excel file",
"line-chart":"Line",
"area-chart":"Area",
"bar-chart":"Bar",
"donut-chart":"Donut",
"pie-chart":"Pie",
"radar-chart":"Radar",
"spline-chart":"Spline",
"splinearea-chart":"Spline Area",
"chart-scale":"Scale",
"chart-x-axis":"X axis",
"chart-y-axis":"Y axis",
"chart-lines":"Lines",
"chart-scale-color":"Scale color",
"chart-xAxis-title":"Title",
"chart-yAxis-title":"Title",
"chart-col-xAxis":"Use left column as xAxis",
"chart-col-yAxis":"Use left column as yAxis",
"chart-row-xAxis":"Use top row as xAxis",
"chart-row-yAxis":"Use top row as yAxis",
"chart-xAxis-range":"Range",
"chart-yAxis-origin":"Origin",
"chart-yAxis-start":"Start",
"chart-yAxis-end":"End",
"chart-yAxis-step":"Step",
"chart-yAxis-note":"* Set all the following parameters to see the effect",
"chart-legend":"Legend",
"chart-row-legend":"Use top row as legend",
"chart-col-legend":"Use left column as legend",
"chart-legend-range":"Legend range",
"chart-legend-align":"Align",
"chart-legend-left":"Left",
"chart-legend-right":"Right",
"chart-legend-center":"Center",
"chart-legend-valign":"Vertical align",
"chart-legend-top":"Top",
"chart-legend-middle":"Middle",
"chart-legend-bottom":"Bottom",
"chart-item":"Data",
"stacked-chart":"Stacked",
"horizontal-chart":"Horizontal",
"chart-range":"Range",
"chart-series-color":"Color",
"add-line":"Add line",
"chart-type":"Type",
"chart-tooltip":"Tooltips",
"chart-label":"Labels",
"chart-data-from":"Data series from",
"chart-columns":"columns",
"chart-rows":"rows",
"chart-markers":"Markers",
"chart-markers-square":"Square",
"chart-markers-triangle":"Triangle",
"chart-markers-diamond":"Diamond",
"chart-markers-round":"Round",
"chart-pie-3d":"3D",
"chart-radar-circle":"Circled lines"
},
tooltips: {
"color": "Font color",
"background": "Background color",
"font-family": "Font family",
"font-size": "Font size",
"text-align": "Horizontal align",
"vertical-align": "Vertical align",
"borders": "Borders",
"borders-no": "Clear borders",
"borders-left": "Left border",
"borders-top": "Top border",
"borders-right": "Right border",
"borders-bottom": "Bottom border",
"borders-all": "All borders",
"borders-outer": "Outer borders",
"borders-top-bottom": "Top and bottom borders",
"borders-color": "Border color",
"align-left": "Left align",
"align-center": "Center align",
"align-right": "Right align",
"align-top": "Top align",
"align-middle": "Middle align",
"align-bottom": "Bottom align",
"span": "Merge",
"wrap": "Text wrap",
"undo": "Undo",
"redo": "Redo",
"format": "Number format",
"increase-decimals":"Increase decimal places",
"decrease-decimals":"Decrease decimal places",
"font-weight": "Bold",
"font-style": "Italic",
"underline": "Underline",
"strike": "Strike",
"hide-gridlines": "Hide/show gridlines",
"hide-headers": "Hide/show headers",
"show-formulas": "Hide/show formulas",
"print-borders": "Hide/show print borders",
"create-filter": "Create/remove filters",
"freeze-columns" : "Freeze/unfreeze columns",
"add-range": "Set name for the selected range",
"conditional": "Conditional formatting",
"add-sheet": "Add Sheet",
"lock-cell": "Lock/unlock cell",
"clear": "Clear",
"add-link": "Add link",
"row": "Rows",
"column": "Columns",
"sheet": "Sheet",
"add-image": "Image",
"add-sparkline": "Graph",
"add-comment": "Comment",
"increase-indent" : "Increase indent",
"decrease-indent": "Decrease indent",
"show-sheet": "Show sheet"
},
menus:{
"remove-sheet": "Remove sheet",
"rename-sheet": "Rename sheet",
"hide-sheet": "Hide sheet",
"file": "File",
"new": "New",
"new-sheet": "New sheet",
"excel-import": "Import from Excel",
"excel-export": "Export to Excel",
"sheet": "Sheets",
"copy-sheet": "Copy to new sheet",
"edit": "Edit",
"undo": "Undo",
"redo": "Redo",
"columns": "Columns",
"insert-column": "Insert column",
"delete-column": "Delete column",
"show-column": "Show column",
"hide-column": "Hide column",
"resize-column": "Resize column",
"rows": "Rows",
"insert-row": "Insert row",
"delete-row": "Delete row",
"show-row": "Show row",
"hide-row": "Hide row",
"resize-row": "Resize row",
"insert": "Insert",
"conditional-format": "Conditional format",
"common": "common",
"text": "text",
"clear": "Clear",
"clear-value":"Values",
"clear-style":"Styles",
"clear-conditional-formats":"Conditional formats",
"clear-dropdown-editors":"Dropdowns and filters",
"clear-comments":"Comments",
"clear-all":"All",
"image": "Image",
"add-image-cell":"Add to cell",
"add-image-top":"Add above cells",
"graph": "Graph",
"add-sparkline":"Add to cell",
"add-chart":"Add above cells",
"data": "Data",
"add-link": "Add link",
"add-range": "Named ranges",
"sort": "Sort",
"sort-asc": "Sort A to Z",
"sort-desc": "Sort Z to A",
"view": "View",
"freeze-columns": "Freeze/unfreeze columns",
"freeze-rows": "Freeze/unfreeze rows",
"hide-gridlines": "Hide/show gridlines",
"hide-headers": "Hide/show headers",
"show-formulas": "Hide/show formulas",
"create-filter": "Create/remove filters",
"add-dropdown": "Add dropdown",
"lock-cell": "Lock/unlock cell",
"print": "Print",
"print-borders": "Hide/show print borders",
"add-comment":"Comment",
"cut": "Cut",
"copy": "Copy",
"paste": "Paste",
"special-paste": "Special paste",
"paste-values": "Values",
"paste-formulas": "Formulas",
"paste-styles": "Styles",
"paste-conditions": "Conditional formats"
},
table:{
"math-error":"#ERROR!",
"math-ref-error":"#REF!",
"format-error":"INCORRECT FORMAT"
},
liveEditor:{
"edit":"Edit:"
},
formats:{
"dateFormat": "mm/dd/yyyy",
"timeFormat": "hh:mm AM/PM",
"longDateFormat": "dd mmmm yyyy",
"fullDateFormat": "mm/dd/yyyy hh:mm AM/PM",
"parseDateTime": "%m/%d/%Y %G:%i:%s",
"parseDate": "%m/%d/%Y",
"currencies": [
"{obj} €",
"¥{obj}",
"R$ {obj}",
"{obj} rub."
]
}
};
To apply a custom locale, you can follow one of the two ways:
hard-code the translated labels according to your locale in the webix.i18n.spreadsheet object;
provide translations to the desired Webix locale:
1. Include translated labels and tooltips into the needed Webix locale as webix.i18n.locales[localeName].spreadsheet.
2. Set the locale with the setLocale method:
webix.i18n.locales["ru-RU"].spreadsheet = {
"labels":{
"common": "Общий",
"currency": "Валюта",
...
},
"tooltips":{
"color": "Цвет текста",
...
}
};
webix.i18n.setLocale("ru-RU");
The second way is more flexible.
Back to top