Ability to get formula values (allows for fetching image urls)

[TheBoroer]

Hey!
Could we please have an option to specify the valueRenderOption setting for the v4 sheets request?

gsheets/gsheets/backend.py

Line 80 in 2c47e19

'valueRenderOption': 'UNFORMATTED_VALUE',

Another method called formula_values() could work too where it just has valueRenderOption: 'FORMULA'.
The reason I need to access formulas is because it's the only way to fetch the image url for cells that hold image content (yup, google sheets cells can hold images now!!). The regular .values() method only returns an empty string.

[xflr6]

Hey,

spounds good to me. Upstream docs:

• https://developers.google.com/sheets/api/reference/rest/v4/ValueRenderOption
• https://developers.google.com/sheets/api/reference/rest/v4/DateTimeRenderOption
• https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values (majorDimension)

Not sure if we should also add DateTimeRenderOption.

I think WorkSheet.values() could just always fetch the values instead of using the loaded ones if a different format is requested.

WDYT?

Let me know if you want to give it a try.