We're pleased to announce the release of SpreadJS v12 sp2. We've been working hard to add requested and new features to expand how you use SpreadJS—it's so much more than a spreadsheet.
With SpreadJS v12 Service Pack 2, you can now apply one of 18 new language packages to the calculation engine. This will provide localized function names and syntax for structured references in your spreadsheets. Your applications can easily apply any of these language packages to provide localized calculations and even create custom language packages.
These languages include:
In order to set the language for the calculation engine, the language package library will need to be referenced after the main SpreadJS file:
Once that file is referenced, the specific language can be set in one line:
In addition to translated function names, name resources like #ALL and #Data are also translated for each language:
Special function logic like that of the LENB and MIDB functions are also changed for each language:
In addition, calculation errors and boolean values are translated:
It should be noted that when a language is changed for the calculation engine, the formulas in the spreadsheet should be recalculated using the sheet.recalcAll(true) function to ensure that all of the formulas calculate correctly for that language.
To get access to these features and enhancements, download SpreadJS v12 Service Pack 2 today!