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.