Search Unity

  1. Unity 6 Preview is now available. To find out what's new, have a look at our Unity 6 Preview blog post.
    Dismiss Notice
  2. Unity is excited to announce that we will be collaborating with TheXPlace for a summer game jam from June 13 - June 19. Learn more.
    Dismiss Notice

Bug Failing to create new Spreadsheet with non-English Locale

Discussion in 'Localization Tools' started by Janniqz, Oct 22, 2020.

  1. Janniqz

    Janniqz

    Joined:
    Sep 7, 2018
    Posts:
    3
    Hello!

    I've come across the same problem described in https://forum.unity.com/threads/unable-to-sync-a-stringtable-to-a-gsheet.974223/ and after some testing found the source of the Problem.

    Whilst I'm not sure if this Solution would apply to the OP of the mentioned Thread aswell, here's what I've found.

    Google Sheets using Locale dependant function names (=SUM would be =SUMME in German) seems to trip up the creation of new Spreadsheets. Pushing / Pulling Data from an existing Spreadsheet generally works fine as this doesn't involve adding any Functions.

    2020-10-22 12_16_43-Einstellungen.png
    =COUNTIF would have to be =ZÄHLENWENN with German Locale

    Whilst I was unable to create a new Spreadsheet with my Locale set to Germany, setting it to United Kingdom (I assume other forms of English will have the same formatting) worked without a hitch. Having to set the global language for all your Google Services to create a Spreadsheet doesn't sound like the best idea though.

    Checking under File -> Spreadsheet Settings the Locale for a specific Spreadsheet can be changed. Maybe this is also possible via the API?

    Hope this helps!
     
    karl_jones likes this.
  2. karl_jones

    karl_jones

    Unity Technologies

    Joined:
    May 5, 2015
    Posts:
    8,418
    Oh thats very interesting. Would you be able to file a bug report for this so we can look into it? https://unity3d.com/unity/qa/bug-reporting
     
  3. Janniqz

    Janniqz

    Joined:
    Sep 7, 2018
    Posts:
    3
    Sure thing! Here's the Case ID: 1286943
     
    karl_jones likes this.