6
Single Quote Prefix in Google Spreadsheet
source link: https://fann.im/blog/2022/05/05/single-quote-prefix-in-spreadsheet/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Single Quote Prefix in Google Spreadsheet
May 5, 2022
When adding/updating cells in Google Spreadsheet, a single quote ('
) was prefixed to the value.
‘2022-05-01
This can be fixed by changing the valueInputOption
to USER_ENTERED
. There’re two options:
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.
If you’re using https://github.com/burnash/gspread, change the value_input_option
.
Was this page helpful?
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK