I’m using appscript to build and insert a table chart into a sheet when a button has been pushed.
var chart = sheet.newChart() .setChartType(Charts.ChartType.TABLE) .addRange(outrange2) .setPosition(2, 12, 35, -5) .setOption('height', 445) .setNumHeaders(1) .setOption('page', 'enable') .build(); sheet.insertChart(chart);
The chart gets created and inserted properly though my users are unable to interact with the contents of this table directly, they can only scroll and change pages.
I have checked to see if there were any required options that need to be enabled when before building the chart, the appscript guide references me to this page when advising on options:
In the reference table and the overview above it states that “Users can select single rows either with the keyboard or the mouse. Users can sort rows by clicking on column headers. The header row remains fixed as the user scrolls. The table fires a number of events corresponding to user interaction”
The table that appears in my sheet is not like the one that appears in the reference and I am unable to copy text from the cells or select individual rows in the newly generated table. When attempting to interact with this table from google sheets it seemingly only allows us to resize and scroll up and down the table.
Are there ways to get around this or some attributes that I am missing to allow us to interact with individual entries from the table chart?
Go to Source
Author: Stephen Catchpole