JDBC Driver for Google Sheets

Build 20.0.7587

Value Render Option

Determines how values should be rendered in the output.

Data Type

string

Default Value

"FormattedValue"

Remarks

FormattedValueValues will be calculated and 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".
UnformattedValueValues 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".
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".

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587