适用于SpreadJS的CalcEngine语言包

SpreadJS为用户提供18种以上的语言包，以支持CalcEngine函数名称，表函数名称，特殊函数逻辑，CalcError名称和布尔值资源的全球化和本地化。使用您选择的语言包，您可以使用自己喜欢的本地语言，而不必担心翻译。

SpreadJS中的默认语言包是“ en”（英语）。为了允许用户使用其他语言工作，SpreadJS中提供了以下语言包以及括号中的语言代码。

1. China/Chinese ('zh')	7. French/français ('fr')	13. Dutch/Nederlands ('nl')
2. Japan/Japanese ('ja')	8. German/Deutsch ('de')	14. Spanish/español ('es')
3. korea/Korean ('ko')	9. Portuguese/português ('pt')	15. Russian/русский ('ru')
4. Swedish/svenska ('sv')	10. Italian/italiano ('it')	16. Danish/dansk ('da')
5. Polish/polski ('pl')	11. Finnish/suomi ('fi')	17. Norwegian Bokmål/norsk bokmål ('no')
6. Czech/cestina ('cs')	12. Hungarian/magyar ('hu')	18. Turkish/Türkçe ('tr')

用户可以使用 languagePackages() 方法 LanguagePackages 类从一种语言切换到另一种语言。如果您要创建和使用自己的自定义语言包，请参阅创建和使用自定义语言包.

示例

下图显示了一个示例图像，说明了不同语言包的本地化功能名称。

下面显示了一个示例图像，该图像说明了不同语言包的本地化表函数名称。

下图显示了说明不同语言包的特殊功能逻辑（示例-LENB函数）的示例图像。

下面显示的示例图像说明了不同语言包的CalcError名称。

下面显示了一个示例图像，说明了用于不同语言包的布尔值资源。

注意: 在SpreadJS中使用语言包时，必须牢记以下几点：

代码

请参考以下示例代码，以将语言包从一种语言切换到另一种语言。

<!DOCTYPE html>
<html>
<head>
<script src="https://code.jquery.com/jquery-2.1.1.min.js" type="text/javascript"></script>
<link href="css/gc.spread.sheets.excel2013white.12.2.0.css" rel="stylesheet" />
<script src="scripts/gc.spread.sheets.all.12.2.0.min.js"></script>
<script src="scripts/gc.spread.sheets.print.12.2.0.min.js"></script>
<script src="scripts/gc.spread.calcengine.languagepackages.12.2.0.min.js"></script> 
<script>
$(document).ready(function ()
{
// 初始化 Spread
 var spread = new GC.Spread.Sheets.Workbook(document.getElementById('ss'), { sheetCount: 1 });
spread.suspendPaint();

// 取得活跃表单
 activeSheet = spread.getSheet(0);
activeSheet.setColumnWidth(1, 130);
activeSheet.setColumnWidth(2, 70);
activeSheet.setColumnWidth(3, 70);
activeSheet.setColumnWidth(4, 70);
activeSheet.setColumnWidth(5, 100);
var source =
[
{ Course: "Calculus", Term: 1, Credit: 5, Score: 80, Teacher: "Nancy.Feehafer" },
{ Course: "P.E.", Term: 1, Credit: 3.5, Score: 85, Teacher: "Andrew.Cencini" },
{ Course: "Political Economics", Term: 1, Credit: 3.5, Score: 95, Teacher: "Jan.Kotas" },
{ Course: "Basic of Computer", Term: 1, Credit: 2, Score: 85, Teacher: "Steven.Thorpe" },
{ Course: "Micro-Economics", Term: 1, Credit: 4, Score: 62, Teacher: "Jan.Kotas" },
{ Course: "Linear Algebra", Term: 2, Credit: 5, Score: 73, Teacher: "Nancy.Feehafer" },
{ Course: "Accounting", Term: 2, Credit: 3.5, Score: 86, Teacher: "Nancy.Feehafer" },
{ Course: "Statistics", Term: 2, Credit: 5, Score: 85, Teacher: "Robert.Zare" },
{ Course: "Marketing", Term: 2, Credit: 4, Score: 70, Teacher: "Laura.Giussani" }
];

var table = activeSheet.tables.addFromDataSource("Table1", 2, 1,  source,GC.Spread.Sheets.Tables.TableThemes.medium2);
spread.resumePaint();
var select = document.getElementById('languageSelect');
select.onchange = function ()
{
var languageName = this.value;
GC.Spread.CalcEngine.LanguagePackages.languagePackages(languageName);
activeSheet.recalcAll(true);
}
});
</script>
</head>
<body>
<table style="width:100%">
<tr>
<td valign="top">
<select id="languageSelect">
<option value="zh">China</option>
<option value="ja">Japan</option>
<option value="ko">korea/Korean </option>
<option value="fr">French</option>
<option value="nl">Dutch</option>
<option value="de">German</option>
<option value="es">Spanish</option>
<option value="pt">Portuguese</option>
<option value="ru">Russian</option>
<option value="sv">Swedish</option>
<option value="it">Italian</option>
<option value="da">Danish</option>
<option value="pl">Polish</option>
<option value="fi">Finnish</option>
<option value="no">Norwegian</option>
<option value="cs">Czech </option>
<option value="hu">Hungarian</option>
<option value="tr">Turkish</option>
</select>
</td>
<td><div id="ss" style="height:360px;width:1000px; margin-left:1px"></div></td>
</tr>
</table>
</body>
</html>