googleapis / googleapis/google-api-nodejs-client

Google sheet api valueRenderOption doesn't work properly

Aperta
#3,384 0 commenti 2 reazioni 1 assegnatario Rivendicata da @sofisl Vedi su GitHub
priority: p2 type: bug
Lingua principale
TypeScript
Stelle
12.2k
Fork
2k
Merge medio
1g 9h
PR unite (30g)
24

Descrizione

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

Guida per i contributori

Apri la guida per i contributori

Valutazione

Questa issue non è ancora stata valutata.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.