Google Sheets API: ValueInputOption

Apr 7, 2019
setValueInputOption

RAW: The values the user has entered will not be parsed and will be stored as-is.

USER_ENTERED: The values will be parsed as if the user typed them into the UI. Numbers will stay as numbers, but strings may be converted to numbers, dates, etc. following the same rules that are applied when entering text into a cell via the Google Sheets UI.

Source

NOTE: To make field to be intepreted as String, use valueInputOption=USER_ENTERED and append ' to the value (e.g. '2018-04-07)

❤️ Is this article helpful?

Buy me a coffee ☕ or support my work via PayPal to keep this space 🖖 and ad-free.

Do send some 💖 to @d_luaz or share this article.

✨ By Desmond Lua

A dream boy who enjoys making apps, travelling and making youtube videos. Follow me on @d_luaz

👶 Apps I built

Travelopy - discover travel places in Malaysia, Singapore, Taiwan, Japan.

Tags
Related articles
Google Sheets App Scripts: Make PubSub Publish CallSetup and Access Google Sheets API With PythonAnalyze Historical Stock Price With Google Sheets: GOOGLEFINANCE ExampleAndroid (Java/Kotlin) Google Sheets API: Metadata (Hide note/string in Sheet)Setup Google Sheets API for Android (Java/Kotlin)Google Sheets: Import Yahoo Finance Key Statistics Like PE ratioGoogle Sheets: Create DropdownGoogle Sheets: Show Elapsed TimePython Google Sheets API: Hide or Show SheetGoogle Sheets: Convert Unix Epoch Timestamp to DateGoogle Sheets App Scripts: Show and Close SidebarGoogle Sheets App Scripts: Show AlertGoogle Sheets Add Button With Apps Script EventPython Google Sheets API: Duplicate SheetPython Google Sheets API: Get Sheet Id by Sheet NameGoogle Sheets Apps Scripts: Custom Function Convert Unix Timestamp to DatePython Google Sheets API: Read All RowsPython Google Sheets API: Update Cell DataPython Google Sheets API: Append New RowGoogle Sheets Lock/Freeze Part of Cell Formula Reference When Copy Cells or Rows