如何在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)