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.
- Google apps script: autoResizeColumn works incorrectly not works as expected
- How to display a user's mouse pointer position in Google Documents?
- Unable to open Google xlsx spreadsheet / Also Google Drive permission Blocked
- Condition if-else
- Apps Script External Stylesheet
- get Entry ID which is used to pre-populate fields (Items) in a Google Form URL
- Allow user with edit privileges to run scripts on a spreadsheet owned by me
- Delete last row with value then find
- Google App Script, Find value and write a result
- How can I save the URL(s), after making a copy (event) of a Google Sheets spreadsheet?
- How to make previous dates data from one tab appear in another tab
- How do I show data from a spreadsheet? it shows "undefined"
- getLastRow() in Apps Script returns error: "This operation is not allowed on cells in typed columns."
- Is it possible get Image from Google Sheets to Google Docs Template when creating
- Dynamically update variable in Spreadsheet popup UI element from google Apps Script
- Save timestamp time in a cell and then the timestamp edit time in another cell
- Keep receiving Sorry, it is not possible to delete all non-frozen rows
- Inserting images into a Sheet as BlobSource using Google Apps Script
- Slack to Google Sheets integration "dispatch failed" error from slash command
- Google Apps Script - Deploy as Webapp - new version every time?
- How to make an auto-timestamped row in Google Sheets
- Calendar Event Time Incorrect in Script despite Correct Formatting in Google Sheets
- How to add automatic page numeration when a table spans over several pages
- Sort a 2d array with 1d array in appscript
- Google App Script Web App GET and POST request blocked by CORS policy
- Spreadsheet database with html
- How to send pdf email attachment by an Event trigger in Google Apps Script?
- Allow script to edit locked cells
- How to use AppendRow
- How can I resolve this `Error: You must select all cells in a merged range to merge or unmerge them.` while merging cells through App Script?