google-apps-scriptgoogle-sheetssetlocale
Spreadsheet locale
I use to set my Google spreadsheet's primary language to Chinese, then I changed it to English. Everything is changed to English except the error messages when I run my script. I have tried to set to other languages like French but the error messages are still in Chinese.
Solution
As have been mentioned by Robin, you can try to use local settings in spreadsheet:
File->Spreadsheet Settings
Or you can try to do it programatically and use setSpreadsheetLocale. That's all the language-related solution we can think of.
- JavaScript function in Google spreadsheets to send QR codes to emails
- Get eventID for Google Calendar Event
- Writing a googlefinance wrapper
- Getting a macro to run using checkbox in google sheets
- Error 500 on POST https://script.googleapis.com/v1/scripts/{scriptId}:run
- Issue in Auto close Modal Dialog - Google App-Script
- Remove duplicates based on one column and keep latest entry in Google sheets (while ignoring blank entries in that column)
- VAT Checker Apps Script
- Trigger python code from Google spreadsheets?
- Same code behaving differently inside and outside function
- Variable isn't being properly referenced across functions
- How to map object values according to the column headers on a Spreadsheet?
- Deploy to Update version of Gmail App Script Extension
- How many time based trigger can your add-on run on a document / user?
- Google Sheets Import CSV popup
- Fastest way to search for a row in a large Google Sheet using/in Google Apps Script
- Google Apps Script showing previous day
- How to use the function .getLastRow() in google script
- Updating appscript dropdown in sidebar after a successful operation
- Getting Range not found when using getRange()
- Creating 'dynamic' pages in web apps
- Navigate to other pages
- How to generate an uuid in google sheet?
- Data is not being updated to Google Sheets from the Flutter app
- Improve performance of onEdit simple trigger
- Google Apps Script attempting to utilize OAuthScopes is giving an error with no details and prevents saving
- Why can't I format my dates after they are returned from this function?
- Printing to the console in Google Apps Script?
- Can I use Google Apps Script instead of Formulas for doing calculations on a spreadsheet?
- Error when trying to use addRange in Embedded Line Chart Builder