Spread Windows Forms 12.0 Product Documentation
Available Language Packages for WinForms
Spread Windows Forms 12.0 Product Documentation > Developer's Guide > Customizing Interaction in Cells > Managing Formulas in Cells > Using Language Package > Available Language Packages for WinForms

While working with spreadsheets, users can make use of the eighteen available built-in language packages in order to localize function names and formula keywords; set up the display of the worksheet and load screentips in their preferred language. 

A custom function name created for a new language can also be referred to as function alias. Each language has a specific language package corresponding to it. By default, Spread uses the English language package. If users want to use the Spread component in their native language, they can either choose from the available list of built-in language packages or create their own language package with function alias representing the same formula logic but in another language of their choice. 

Spread for WinForms supports localization for the following languages:

  1. Chinese
  2. Czech
  3. Danish
  4. Dutch
  5. Finnish
  6. French
  7. German
  8. Hungarian
  9. Italian
  10. Japanese
  11. Korean
  12. Norwegian
  13. Polish
  14. Portuguese
  15. Russian
  16. Spanish
  17. Swedish
  18. Turkish
Note: The default language package is in English language and this will be used as the fallback scenario.

Using Code

Refer to the following example code in order to use the available language package in a spreadsheet.

C#
Copy Code

// Assigning Formula

 fpSpread1.Sheets[0].Cells[0, 0].Formula = "Sum(1)";

// Setting Spanish language package
fpSpread1.AsWorkbook().WorkbookSet.LanguagePackage = LanguagePackage.Spanish;

// Now we get formula in Spanish Language
MessageBox.Show(fpSpread1.Sheets[0].Cells[0, 0].Formula.ToString());

VB
Copy Code

'Assigning Formula

fpSpread1.Sheets(0).Cells(0, 0).Formula = "Sum(1)"

'Setting Spanish language package
fpSpread1.AsWorkbook().WorkbookSet.LanguagePackage = LanguagePackage.Spanish

'Now we get formula in Spanish Language
MessageBox.Show(fpSpread1.Sheets(0).Cells(0, 0).Formula.ToString())