Google Sheets value input options for write operations.
Determines how input values should be interpreted when writing to cells.
ValueInputOption()Values are stored exactly as provided without any parsing. For example, "=1+2" will be stored as the literal string "=1+2".
Values are parsed as if the user typed them into the UI. For example, "=1+2" will be parsed as a formula and display "3". Numbers, dates, and formulas are automatically detected and parsed.