Translate ui to another language

Posted by: samuelstein on 8 September 2017, 1:10 am EST

    • Post Options:
    • Link

    Posted 8 September 2017, 1:10 am EST

    hello,

    your great library has built-in support for English, Chinese and Japanese culture. Is it also possible to translate the interface to another language? how could this be achieved? Is a custom resource file needed?

    thanks in advance

  • Posted 8 September 2017, 1:10 am EST

    Hello,

    Currently we only have support for eng, ch and jp culture. May I know which language support are you looking for?

    Thanks,

    Deepak Sharma

  • Posted 8 September 2017, 1:10 am EST

    I’m looking for german translation. is there a change of creating it for myself?

  • Posted 8 September 2017, 1:10 am EST

    Hello,

    I have asked the development team about the same. I will let you know as soon as I hear anything on this.

    The tracking id for this issue is #244390

    Thanks,

    Deepak Sharma

  • Posted 12 November 2017, 11:48 pm EST

    any progress here?

  • Posted 10 December 2017, 6:30 pm EST

    Hello,

    This issue is still with the development team. I have asked for an update on this issue. I will let you know as soon as I get any information on this.

    Thanks,

    Deepak Sharma

  • Posted 22 March 2018, 11:56 pm EST

    Do you already got feedback on this issue? It’s also ok if i could get a dirty workaround for changing the language in the filter

  • Posted 21 August 2018, 12:50 am EST

    I fixed it with copying japanese language file and translating it into german. you could use it if you want.

  • Posted 17 September 2020, 10:28 pm EST

    Hello,

    this thread is old, but the topic is still actual… any news about the localization?

    @Stein are you still using the translation?

    thx

  • Posted 20 September 2020, 11:58 pm EST

    Hi,

    You may refer to the following demo which demonstrates how we could use apply custom localization for SpreadJS:

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

    Regards

  • Posted 21 September 2020, 12:43 am EST

    Hello Sharad,

    thx for reply.

    i know this demo, but this is not the User Interface like the Ribbon Toolbar on Menus.

    -Stephan

  • Posted 21 September 2020, 6:28 pm EST

    Hi Stephan,

    By ribbon-like toolbar you mean SpreadJS web designer similar to this one, right?

    https://www.grapecity.com/spreadjs/designer/content/index.html

    In the case of the designer, you need to update the src/common/resorces.en.js file to localize the string resources into any language.

    Regards

  • Posted 21 September 2020, 6:43 pm EST

    Hi,

    yes. i mean this one. I know that i can do the localization by myself in the resorces file… but is there now localization available by grapecity?

    Pretty sure that i am not your only user in germany, right?

    Thanks

    Stephan

  • Posted 22 September 2020, 4:32 pm EST

    Hi Stephan,

    For now, only translations are available only for Chinese, Japanese and Korean. Further, I’ve asked the PM if there are any future plans to add more translations. I’ll update you as soon as I get more information regarding this. (Internal tracking Id: SJS-5890)

    Regards

  • Posted 17 February 2021, 2:06 am EST

    Any update on this topic? We’re looking for a multi language solution for the designer ribbon as well. Where is this on your pipeline?

  • Posted 22 February 2021, 6:49 pm EST

    Hi Alex,

    This feature is currently in our backlog and Devs are looking into it. As of now, we don’t have any ETA. Further, we have added you as a corresponded to this case. We will update you once we have any information regarding this feature.

    Regards

    Avinash

  • Posted 24 February 2021, 2:15 pm EST

    Hi Alex,

    The Devs provided the workaround by which you could set the custom language for the designer. Please refer to the following attached sample and let us know if you face any issues.

    Regards

    Avinash

    designer.zip

  • Posted 6 August 2021, 12:39 am EST - Updated 3 October 2022, 12:34 am EST

    EDIT: Solved!

    Hi Avinash,

    I’m also in the process of setting up translations but I’m hitting issues. Our use case is a bit more involved than the demo above as we use Webpack 4 and @grapecity/spread-sheets-designer-react.

    With the react wrapper I can confirm that the line in the react wrapper that initializes the Designer has DesignerRes with translated strings but the UI does not reflect that everywhere.

    For example, I get translations in the Hyperlink modal dialog but not on the ribbon and not in the barcode dialog.

    The import order is as follows:

    
    import '@grapecity/spread-sheets-designer-resources-en';
    import GC from '@grapecity/spread-sheets';
    import * as Excel from '@grapecity/spread-excelio';
    
    // forEach loop on DesignerRes.res // recursive loop on DesignerRes.res updating properties // Proxy injection for linking our translation system // DesignerRes.res reassignment
    // from the above only the last one does not work, the rest gives the same symptoms
    
    import GCDesigner from '@grapecity/spread-sheets-designer';
    
    // later, in another file we import
    
    import type GC from '@grapecity/spread-sheets-designer';
    import { Designer } from '@grapecity/spread-sheets-designer-react';
    
    // <Designer /> in render function
    
    

    Is this a known issue? Is there anything else I could check to diagnose why it’s not using translated strings?

    Solution:

    The import order was wrong because webpack. I moved the overriding as high in the import tree as I could and it worked. Managed to debug it by beautifying the designer source and checking what “…/localization/resentry” had set on initialization. Thanks for not obfuscating the source because otherwise I would run in circles far longer.

  • Posted 8 August 2021, 10:47 pm EST

    Hi,

    We are glad to know that the issue has been solved at your end. Feel free to revert back if you have any queries regarding this issue.

    Regards,

    Avinash

  • Posted 16 August 2021, 6:13 am EST - Updated 3 October 2022, 12:34 am EST

    Hi again, we found one place which is not translated with res substitution - calcEngine descriptions in ./src/calcEngine.res.en.ts

    Is there a way to translate these?

    Thanks,

    Piotr

  • Posted 17 August 2021, 10:02 pm EST

    Hi,

    For this, you need to use the custom localization feature of spreadJS. Please refer to the following demos and let us know if you face any issues.

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

    language Packages: https://www.grapecity.com/spreadjs/demos/features/calculation/language-package/purejs

    Regards

    Avinash

  • Posted 18 August 2021, 10:00 pm EST - Updated 3 October 2022, 12:34 am EST

    Hi,

    I successfully set the culture to ‘de’ before initializing SpreadJS for my testing and it nicely translates formulas in cells but the ribbon still has English operators and the formula modal strings are not in DesignerRes.res (same for Pivot, btw I fixed Mateusz’s issue in https://www.grapecity.com/forums/spreadjs/pivot-add-on-not-enabled and now I’m trying to translate it too).

    I set the culture and load the pivot addon before doing the translation injection into DesignerRes.res so from what I can gather, the strings are not in there but a part of calcEngine and pivot respectively. I suspect it’s possible to translate these by setting a custom localization as detailed in https://www.grapecity.com/spreadjs/demos/features/culture/custom-localization.

    Is there a way to get the resource objects for calcEngine and pivot that should be set by setting the cultureInfo? I really don’t want to manually maintain a list of overrides just to get translations working + I don’t know the resource paths that should be used for translating the modal windows (see screenshots).

  • Posted 19 August 2021, 8:32 pm EST

    Hi,

    We are sorry but currently translating the functions commands inside the ribbon is not supported but I have escaped this issue to the dev team and asked them regarding the same. We will update you once we get information from the team.

    Regards

    Avinash

  • Posted 12 October 2021, 7:24 pm EST

    Hi,

    Got a question regarding this:

    The SpreadJS component itself has extensive customization options for localization. With this release, we have extended that functionality to include the Designer Component.
    
    Now all of the UIs in the ribbon can be localized to satisfy your customer's language requirements.
    

    via https://www.grapecity.com/blogs/spreadjs-v14.2-release

    Is this regarding pivot and functions?

    Thanks, Piotr

  • Posted 13 October 2021, 2:57 pm EST

    Hi Piotr,

    We were unable to translate the formulas dropdown using this feature hence we have asked the concerned team regarding the same. We will get back to you once we have more findings related to the issue.

    Regards

    Avinash

  • Posted 19 October 2021, 7:50 pm EST

    Hi Piotr,

    The devs informed us that all All the function is not part of localization, You need to modify the command, then apply to the config to achieve the goal. Please refer to the following code snippet and attached sample that demonstrates the same

    
    var customMoreFunctions = GC.Spread.Sheets.Designer.getCommand('	');
    		customMoreFunctions.dropdownList[0].subItems[0].text = "AVEDEV_AAA";
    
    		var config = GC.Spread.Sheets.Designer.DefaultConfig;
    		config.ribbon[2].buttonGroups[1].commandGroup.children[9] = 'customMoreFunctions';
    		config.commandMap = {
    			customMoreFunctions: customMoreFunctions
    		}
    		var designer = new GC.Spread.Sheets.Designer.Designer(document.getElementById("designer_host"));
    		designer.setConfig(config);
    
    

    Regards,

    Avinash

    sjs_designer_cdn.zip

Need extra support?

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

Learn More

Forum Channels