Spread Windows Forms 13.0 Product Documentation
Spread Windows Forms 13.0 Product Documentation / Developer's Guide / Customizing Interaction in Cells / Managing Formulas in Cells / Using Language Package / Available Language Packages for WinForms
In This Topic
    Available Language Packages for WinForms
    In This Topic

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