Google sheet api valueRenderOption doesn't work properly

Open
  • Is something wrong?
#3,384 0 comments 2 reactions 1 assignee View on GitHub

Maintainers usually reply within 2 days

@sofisl is already working on this.

Since Nov 17, 2023.

Assessment

This issue has not been assessed yet.

Description

priority: p2 type: bug
  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
  1. Did someone already solve this?
  • No
  1. 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.
  sheetsApi.spreadsheets.values.get({
  		spreadsheetId,
  		range,
  		valueRenderOption: 'FORMATTED_VALUE',
  	})

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

Dominant language
TypeScript
Stars
12.3k
Forks
2k
Avg merge
3d 10h
Merged PRs (30d)
9

Getting set up

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from googleapis/google-api-nodejs-client

All issues in googleapis/google-api-nodejs-client

Similar issues

More TypeScript issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.