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.
=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?
