edit option in table chart

26 views
Skip to first unread message

UB

unread,
Mar 8, 2017, 8:41:09 AM3/8/17
to Google Visualization API
I have generated a table chart from spreadsheet data, is there a way that when i click on particular record on table chart i should be able to edit it and it should also reflect in spreadsheet(spreadsheet should get updated)

Daniel LaLiberte

unread,
Mar 8, 2017, 9:44:14 AM3/8/17
to Google Visualization API
There is no built-in support for editing the cells of a Table chart and sending the values back to the spreadsheet.  Such a capability is possible, however, if you apply a suitable amount of code.

On Wed, Mar 8, 2017 at 8:41 AM, UB <ugan...@logicmatter.com> wrote:
I have generated a table chart from spreadsheet data, is there a way that when i click on particular record on table chart i should be able to edit it and it should also reflect in spreadsheet(spreadsheet should get updated)

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsub...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/95663d6a-5697-4cf4-b84b-89aa30369c23%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--

UB

unread,
Mar 8, 2017, 10:03:57 AM3/8/17
to Google Visualization API
can u give me some idea on how to achieve that functionality,so far i have use getSelection() to get the value of selected record,is there a way i can get the rowID and columnID of the selected record

On Wednesday, March 8, 2017 at 8:14:14 PM UTC+5:30, Daniel LaLiberte wrote:
There is no built-in support for editing the cells of a Table chart and sending the values back to the spreadsheet.  Such a capability is possible, however, if you apply a suitable amount of code.
On Wed, Mar 8, 2017 at 8:41 AM, UB <ugan...@logicmatter.com> wrote:
I have generated a table chart from spreadsheet data, is there a way that when i click on particular record on table chart i should be able to edit it and it should also reflect in spreadsheet(spreadsheet should get updated)

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsub...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.



--

Daniel LaLiberte

unread,
Mar 8, 2017, 10:09:15 AM3/8/17
to Google Visualization API
It will not be easy to support editing.  You'll have to do a fair amount of hacking just to figure out which cell was clicked on (since we don't have support for that yet), and then you'll have to replace the content (or overlay it) with a text editor.  Changing the appropriate cell value in the DataTable will be easy, but submitting the changes back to the spreadsheet could prove to be a much larger obstacle, which seems possible if there is support for it on the spreadsheet side.

On Wed, Mar 8, 2017 at 10:03 AM, UB <ugan...@logicmatter.com> wrote:
can u give me some idea on how to achieve that functionality,so far i have use getSelection() to get the value of selected record,is there a way i can get the rowID and columnID of the selected record

On Wednesday, March 8, 2017 at 8:14:14 PM UTC+5:30, Daniel LaLiberte wrote:
There is no built-in support for editing the cells of a Table chart and sending the values back to the spreadsheet.  Such a capability is possible, however, if you apply a suitable amount of code.
On Wed, Mar 8, 2017 at 8:41 AM, UB <ugan...@logicmatter.com> wrote:
I have generated a table chart from spreadsheet data, is there a way that when i click on particular record on table chart i should be able to edit it and it should also reflect in spreadsheet(spreadsheet should get updated)

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsubscr...@googlegroups.com.



--

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsub...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.

Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/f40c4455-3281-44e6-8639-04b7b6492e30%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.



--

UB

unread,
Mar 8, 2017, 10:19:34 AM3/8/17
to Google Visualization API
Daniel,is it better to use the HTML services(not using the chart API) for displaying spreadsheet data as table and perform edit operation on it..?



On Wednesday, March 8, 2017 at 8:39:15 PM UTC+5:30, Daniel LaLiberte wrote:
It will not be easy to support editing.  You'll have to do a fair amount of hacking just to figure out which cell was clicked on (since we don't have support for that yet), and then you'll have to replace the content (or overlay it) with a text editor.  Changing the appropriate cell value in the DataTable will be easy, but submitting the changes back to the spreadsheet could prove to be a much larger obstacle, which seems possible if there is support for it on the spreadsheet side.
On Wed, Mar 8, 2017 at 10:03 AM, UB <ugan...@logicmatter.com> wrote:
can u give me some idea on how to achieve that functionality,so far i have use getSelection() to get the value of selected record,is there a way i can get the rowID and columnID of the selected record

On Wednesday, March 8, 2017 at 8:14:14 PM UTC+5:30, Daniel LaLiberte wrote:
There is no built-in support for editing the cells of a Table chart and sending the values back to the spreadsheet.  Such a capability is possible, however, if you apply a suitable amount of code.
On Wed, Mar 8, 2017 at 8:41 AM, UB <ugan...@logicmatter.com> wrote:
I have generated a table chart from spreadsheet data, is there a way that when i click on particular record on table chart i should be able to edit it and it should also reflect in spreadsheet(spreadsheet should get updated)

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsub...@googlegroups.com.



--

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsub...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.



--
Reply all
Reply to author
Forward
0 new messages