Localization in spreadJS

Posted by: jekin.desai on 13 December 2020, 9:49 pm EST

    • Post Options:
    • Link

    Posted 13 December 2020, 9:49 pm EST - Updated 3 October 2022, 12:59 am EST

    How to implement localization using spreadJS v13.2.3 in angular 10 app. Could you give me sample for at least 2 language.

    Language supported should be:

    German, Italian, Japanese, French, Polish and Spanish

    Text translation supported should be for:

    Context menu, Filters and formula. (I have attached screenshot of what thing need to be localize.

  • Posted 14 December 2020, 6:45 pm EST

    Hi Jenkin,

    You may use localization for the required functionality. Please refer to the attached Demo references and let us know if you face any issues.

    Localization demo: https://www.grapecity.com/spreadjs/demos/features/culture/localization/angular

    customLocalization: https://www.grapecity.com/spreadjs/demos/features/culture/custom-localization/angular

  • Posted 14 December 2020, 10:28 pm EST

    Localization mentioned is only for Chinese ,Japanese and Korean what abt other languages as i mentioned above

    German, Italian, Japanese, French, Polish and Spanish

  • Posted 14 December 2020, 11:18 pm EST

    Hi Jekin,

    For these, you need to create a custom culture. Please refer to the following references and let us know if you face any issues

    custom culture Demo: https://www.grapecity.com/spreadjs/demos/features/culture/custom-localization/angular

    You may also refer to some of the language-translation resources here: https://github.com/GrapeCity/spreadjs-resources/tree/master/SpreadJS%20v13

    Regards,

    Avinash

  • Posted 17 December 2020, 7:54 pm EST

    Hi, I couldn’t find translation for Japanese and Polish language, could you pls provide resource for that.

  • Posted 20 December 2020, 6:32 pm EST

    Hi Jekin,

    SJS provides the built-in resource file for the Japanese but for the Polish, you need to create your own custom resource translation.

    for more information please refer to the following references.

    https://unpkg.com/@grapecity/spread-sheets-resources-ja@14.0.4/dist/gc.spread.sheets.resources.ja.min.js

    Built supported resources Demo: https://www.grapecity.com/spreadjs/demos/features/culture/localization/purejs

    custom Translation Demo: https://www.grapecity.com/spreadjs/demos/features/culture/custom-localization/angular

    Regards

    Avinash

  • Posted 28 January 2021, 11:12 pm EST

    Hi,

    Since Japanese is in built and for Polish, French, Spanish, German i’ve to use custom resource translation. i have no idea how to use in built resource(Japanese) and custom(Polish, French, Spanish, German) at the same time( since user can change the language from dropdown and selected language translation should update spreadJS table in runtime).

    So is it possible if you can give me resource translation (.js) file for Japanese(similar to French, Spanish, German which i’ll treat as custom resource translation and use it accordingly)

    Note: i’m using spreadJs v13

  • Posted 31 January 2021, 3:33 pm EST

    Hi,

    Any update?

  • Posted 2 February 2021, 3:52 pm EST

    Hi,

    Any update?

  • Posted 2 February 2021, 4:31 pm EST

    Hi Jekin.

    Apologies for the delayed response. if want to use the built-in culture then you just need to import the resource package and change the culture whenever you want you don’t need o add the built-in culture as custom translation. Please refer to the following code snippet and let us know if you face any issues.

    
    import '@grapecity/spread-sheets-resources-ja';
     changeCultureName () {
            GC.Spread.Common.CultureManager.culture("ja-jp");
        }
    
    

    Localization Demo: https://www.grapecity.com/spreadjs/demos/features/culture/localization/angular

    Regards

    Avinash

  • Posted 2 February 2021, 5:40 pm EST

    ok, Thanks.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels