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:
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()) |