ValueRenderOption

Determines how values should be rendered in the output.

Enums
FORMATTED_VALUEValues 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, ifA1 is1.23 andA2 is=A1 and formatted as currency, thenA2 would return"$1.23".
UNFORMATTED_VALUEValues will be calculated, but not formatted in the reply. For example, ifA1 is1.23 andA2 is=A1 and formatted as currency, thenA2 would return the number1.23.
FORMULA

Values will not be calculated. The reply will include the formulas. For example, ifA1 is1.23 andA2 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, seeAbout date & time values.

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-03-21 UTC.