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.

Read the full release

SpreadJS v12 Service Pack 2 Language Packages

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:

  • England/english ('en')(default)
  • China/Chinese ('zh')
  • Japan/Japanese ('ja')
  • korea/Korean ('ko')
  • French/français ('fr')
  • Dutch/Nederlands ('nl')
  • German/Deutsch ('de')
  • Spanish/español ('es')
  • Portuguese/português ('pt')
  • Russian/русский ('ru')
  • Swedish/svenska ('sv')
  • Italian/italiano ('it')
  • Danish/dansk ('da')
  • Polish/polski ('pl')
  • Finnish/suomi ('fi')
  • Norwegian Bokmål/norsk bokmål ('no')
  • Czech/čeština ('cs')
  • Hungarian/magyar ('hu')
  • Turkish/Türkçe ('tr')

In order to set the language for the calculation engine, the language package library will need to be referenced after the main SpreadJS file:


<script src=".../gc.spread.sheets.all.12.2.0.min.js" type="text/javascript"></script>
<script src=".../gc.spread.calcengine.languagepackage.12.2.0.min.js" type="text/javascript"></script>

Once that file is referenced, the specific language can be set in one line:

GC.Spread.CalcEngine.LanguagePackages.languagePackages('fr');

In addition to translated function names, name resources like #ALL and #Data are also translated for each language:

SpreadJS v12 Service Pack 2 - Language Packages

Special function logic like that of the LENB and MIDB functions are also changed for each language:

SpreadJS v12 Service Pack 2 - Language Packages

In addition, calculation errors and boolean values are translated:

SpreadJS v12 Service Pack 2 - Language Packages

SpreadJS v12 Service Pack 2 - Language Packages

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!

Try SpreadJS 12's new features now

Download SpreadJS 12

Download Now!