Spread for WinForms provides a set of eighteen language packages including support for Chinese, Czech, Danish, Dutch, Finnish, French, German, Hungarian, Italian, Japanese, Korean, Norwegian, Polish, Portuguese, Russian, Spanish, Swedish and Turkish languages.
In case, your preferred language doesn't come under the list of the available built-in packages, you can create a custom language package as per your requirements.
In order to create and use a custom language package in your spreadsheet, you can follow the steps shared below:
Step 1 - Create the custom language package with function alias.
C# |
Copy Code
|
---|---|
// Creating a custom French language package with functions alias, and mapping BuiltinFunction and StructuredItemSpecifier. private LanguagePackage CreateCustomFrenchLanguagePackage() { LanguagePackage languagePackage = new LanguagePackage("CustomFrench", "français"); languagePackage.CreateFunctionAlias(BuiltinFunction.SUM, "SOMME"); languagePackage.CreateFunctionAlias(BuiltinFunction.SUBTOTAL, "SOUS.TOTAL"); languagePackage.MapAlias(StructuredItemSpecifiers.Headers, "En-têtes"); languagePackage.MapAlias(StructuredItemSpecifiers.Totals, "Totaux"); return languagePackage; } |
VB |
Copy Code
|
---|---|
Private Function CreateCustomFrenchLanguagePackage() As LanguagePackage ' Creating a custom French language package with functions alias, and mapping BuiltinFunction and StructuredItemSpecifier. LanguagePackage languagePackage = new LanguagePackage("CustomFrench", "français") |
Step 2 - Assign the custom language using LanguagePackage property.
C# |
Copy Code
|
---|---|
// Assigning custom language using LanguagePackage property. |
VB |
Copy Code
|
---|---|
'Assigning custom language using LanguagePackage property. |
Step 3 - Use the custom language package, set the formulas in the spreadsheet and calculate cell values.
C# |
Copy Code
|
---|---|
//Setting cell texts and formulas. |
VB |
Copy Code
|
---|---|
'Setting cell texts and formulas. 'Adding a table. |