Hello, I have been using I2Localization with Unity and I have come upon some weird issue where some text appears as "#ERROR" even though a translation for that language exist in the I2Languages.
This happens randomly, though I have noticed it mostly happens when non-latin characters, like arabic or korean, and happens after the application has been built, leading me to believe daily localization updates routine might be causing it, although I am not sure.
Can anybody help me with this? I have included an image of the error, if it helps.
Does you spreadsheet contains formulaes?
I2 Localization doesn't use the #ERRROR format, that's an spreadsheet formulae error.
My guess is that some of your spreadsheet cells contains a formulae that its randomly failing to evaluate, and so, that cell becomes #ERROR. Then, when I2 Localization downloads the spreadsheet, that's the value it uses for the translation.
Can you double check that all your cells are properly formed, and If you are using "=GOOGLETRANSLATE(...)" or similar functions in you spreadsheet, try replacing them by the resulting value. That way, the spreadsheet will not fail to evaluate and never return #ERROR. If the problem is because GOOGLETRANSLATE formulae, it could be that there are too many of them, and when downloading the full spreadsheet, Google is complaining of too many translations in a short time.
Hope that helps,
Are you Give I2L 5 stars!
Are you Please lets us know how to improve it!