googleapis / googleapis/google-api-nodejs-client

Google sheet api valueRenderOption doesn't work properly

Open
#3,384 0 comments 2 reactions 1 assignee Claimed by @sofisl View on GitHub
priority: p2 type: bug
Dominant language
TypeScript
Stars
12.2k
Forks
2k
Avg merge
1d 9h
Merged PRs (30d)
24

Description

1) Is this a client library issue or a product issue?
- It looks like the library issue as it works fine with product direct API

2) Did someone already solve this?
- No
3) Do you have a support contract?
- No

#### Environment details

- OS: Mac
- Node.js version: v18.16.0
- npm version: 9.5.1
- `googleapis` version: 128.0.0

#### Steps to reproduce

1. I tried to fetch spreadsheet values using the below method. but it returns numeric values as it is, when I use the google API Explorer, it returns all the values as strings. I want to get all the values as strings in this case.

```ts
sheetsApi.spreadsheets.values.get({
spreadsheetId,
range,
valueRenderOption: 'FORMATTED_VALUE',
})
```

https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/get

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.