Show / Hide Table of Contents

Enum SpreadsheetsResource.ValuesResource.UpdateRequest.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 ResponseValueRenderOptionEnum

Fields

Name Description
FORMATTEDVALUE

Values will be calculated & formatted in the reply 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".

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