Stay organized with collectionsSave and categorize content based on your preferences.
Determines how values should be rendered in the output.
Enums
FORMATTED_VALUE
Values will be calculated & formatted in the response according to the cell's formatting. Formatting is based on the spreadsheet's locale, not the requesting user's locale. For example, ifA1is1.23andA2is=A1and formatted as currency, thenA2would return"$1.23".
UNFORMATTED_VALUE
Values will be calculated, but not formatted in the reply. For example, ifA1is1.23andA2is=A1and formatted as currency, thenA2would return the number1.23.
FORMULA
Values will not be calculated. The reply will include the formulas. For example, ifA1is1.23andA2is=A1and formatted as currency, then A2 would return"=A1".
Sheets treats date and time values as decimal values. This lets you perform arithmetic on them in formulas. For more information on interpreting date and time values, seeAbout date & time values.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-03-21 UTC."],[],[],null,["# ValueRenderOption\n\nDetermines how values should be rendered in the output.\n\n| Enums ||\n|---------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\n| `FORMATTED_VALUE` | Values will be calculated \\& formatted in the response according to the cell's formatting. Formatting is based on the spreadsheet's locale, not the requesting user's locale. For example, if `A1` is `1.23` and `A2` is `=A1` and formatted as currency, then `A2` would return `\"$1.23\"`. |\n| `UNFORMATTED_VALUE` | Values will be calculated, but not formatted in the reply. For example, if `A1` is `1.23` and `A2` is `=A1` and formatted as currency, then `A2` would return the number `1.23`. |\n| `FORMULA` | Values will not be calculated. The reply will include the formulas. For example, if `A1` is `1.23` and `A2` is `=A1` and formatted as currency, then A2 would return `\"=A1\"`. Sheets treats date and time values as decimal values. This lets you perform arithmetic on them in formulas. For more information on interpreting date and time values, see [About date \\& time values](https://developers.google.com/workspace/sheets/api/guides/formats#about_date_time_values). |"]]
