Enum SpreadsheetsResource.ValuesResource.BatchGetRequest.ValueRenderOptionEnum

How values should be represented in the output. The default render option is ValueRenderOption.FORMATTED_VALUE.

Namespace: Google.Apis.Sheets.v4

Assembly: Google.Apis.Sheets.v4.dll

Syntax

public enum SpreadsheetsResource.ValuesResource.BatchGetRequest.ValueRenderOptionEnum

Fields

Name	Description
FORMATTEDVALUE	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".
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.
UNFORMATTEDVALUE	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.