How to get a cell range from Google Drive Comments API

user_5094001 0
Viewed 532

I am trying to find out to which cell a comment belongs to in Google Spreadsheet. From the API I get

{'kind': 'drive#comment',
   ...
   'anchor': '{"type":"workbook-range","uid":0,"range":"285502171"}',
   ...}

Yet I am unable to transform the integer-valued range to the appropriate cell range (i.e. A1:A2) in the spreadsheet. According to the documentation the anchor should look completely different. Based on the doc I'd assume that there is supposed to be a region class of type matrix. There is no mention of workbook-range in the doc in the first place.

google-drive-api google-sheets-api
1 Answers

Based from this SO related post,

The Anchoring Comments feature from the Google Drive API is intended for non-Google Docs editors files, not for Google Documents. Unfortunately, at this time the Document Service from Google Apps Script doesn't include a Class Comment to handle comments and discussions.

You could probably do this with non-Google editor files.

user_101053210
Related