Percentage formatting with API

Hello,

I'm trying to automate the modification of multiple spreadsheets with the API, and I'm bringing a detailed formula to my columns. The displayed value is a percentage so I'm bringing a value between 0 and 1, but I would like to directly format the column in percentage.

I've observed on an extract after setting manually the column that I've:

"displayValue": "95%"
"value": 0.949367088607595

Does that mean I need to set the value I'm displaying? As I'm calculating it, that looks to be two loops, one to apply the formula to my cell, then one to rewrite the result as a percentage which looks unconvenient.

Is there a way to set-up directly the column as percentage?

Thanks a lot,

Jérémy

Best Answer

Answers