ValueInputOption
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-09-03 UTC.
[null,null,["Last updated 2024-09-03 UTC."],[[["Specifies how input data is understood by the system, crucial for correct data handling."],["Offers three options: a default to be avoided, `RAW` for storing input as-is, and `USER_ENTERED` for parsing input like user UI entries."],["`USER_ENTERED` option enables automatic conversion of strings into numbers, dates, and other formats based on Google Sheets UI rules."]]],["The provided content defines input data interpretation options. `RAW` stores user-entered values without parsing. `USER_ENTERED` parses values as if entered in the Google Sheets UI, potentially converting strings to numbers or dates. `INPUT_VALUE_OPTION_UNSPECIFIED` is a default that should not be used. These options control how input is handled, whether it's stored as-is or parsed and potentially modified.\n"]]