Show / Hide Table of Contents

Enum SpreadsheetsResource.ValuesResource.AppendRequest.ResponseValueRenderOptionEnum

Determines how values in the response should be rendered. The default render option is FORMATTED_VALUE.

Namespace: Google.Apis.Sheets.v4
Assembly: Google.Apis.Sheets.v4.dll
Syntax
public enum SpreadsheetsResource.ValuesResource.AppendRequest.ResponseValueRenderOptionEnum

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.

In this article
Back to top Generated by DocFX
OSZAR »