如何在Google App脚本表中设置百分比格式

如何在Google App脚本表中设置百分比格式

问题描述:

作为Google App脚本仪表板的一部分,我有下表:

As part of a Google App Script Dashboard, I have the following table:

var tableChart = Charts.newTableChart()
.setDataViewDefinition(Charts.newDataViewDefinition().setColumns([1,10,15]))
.build();

第10栏标记为总计百分比",在我的Google电子表格中,其格式为"0.00%".但是,tableChart不考虑格式设置,而是将值显示为"0.0000"

Column 10 is labelled "Percentage of Total" and in my google spreadsheet formatted as "0.00%". The tableChart however does not take the formatting into account and displays the value as "0.0000"

如何将tableChart中特定列的格式设置为"0.00%"?

How does one set the formatting of a specific column in the tableChart to "0.00%"?

问候 简(Jann)

功能请求已添加到问题跟踪器

A feature request has been added to the issue tracker, Issue 3063. Visit and star it to receive updates.