Search Unity

Bug Google Sheets "Id" Field Too Big Using Localization

Discussion in 'Localization Tools' started by cassius, Jan 24, 2023.

  1. cassius

    cassius

    Joined:
    Aug 5, 2012
    Posts:
    125
    When I export to Google Sheets (and then later import it), the size of the number of the ID field is often too large for google sheets to handle. I end up with a number like 1.20508E+15 regardless of the <type> of number I defined for the field in Google Sheets. Of course once I import it back into Unity, I end up with either a bunch of replicated fields, or missing a bunch of fields since many end up with the same ID number. Surely the ID field should never need to be 15 numbers long?

    After looking around for a while, it seems Google Sheets doesn't handle huge numbers. I'd be surprised if nobody else has had this problem or mentioned it.

    I'm on 1.4.2.

    Thanks
     
    cassius, Jan 24, 2023
    #1

  2. karl_jones

    karl_jones

    Unity Technologies

    Joined:
    May 5, 2015
    Posts:
    8,276
    karl_jones, Jan 24, 2023
    #2