在Google表格中查找评论的位置 [英] Finding location of comments within a Google Sheet

问题描述

我能够检索电子表格的所有评论.但是，我想知道注释锚定的确切工作表和单元格范围.我已经查看了Comment.list()方法返回的comment资源的anchor属性内的值:

var commentsResource = Drive.Comments.list(ss.getId());

在查看结果时，我看到的唯一类似于位置的是资源的"anchor"属性内json字符串中的"range"键:

"{"type":"workbook-range","uid":0,"range":"1303483326"}"

我在 an 锚属性中找到了文档，但我认为它不适用于电子表格注释的文档.这就是我发现的内容: https://developers.google.com/drive/v3/web/manage-comments 上面没有有关如何解释范围"键的值的描述.文件中没有描述的其他内容.

关于如何解释上述范围值的任何想法?指向任何文档的指针都很棒.我确实已经穷举了一下，但是一定不能问正确的问题，因为我找不到关于此属性的任何文档.指导非常感谢.

解决方案

目前，这是不可能的.请为此功能加注星标:提供对Google表格中评论的读/写访问权限

相关问答

• Google Apps脚本电子表格注释自动化
• 在Google文档中以编程方式创建锚定注释

I am able to retrieve all comments for a spreadsheet. However, I want to know the exact sheet and cell range the comment is anchored to. I have looked at the values within the anchor property of the comments resource that is returned by the Comments.list() method:

var commentsResource = Drive.Comments.list(ss.getId());

In looking at the results, the only thing that I see that resembles a location is the "range" key in the json string within the "anchor" property of the resource:

"{"type":"workbook-range","uid":0,"range":"1303483326"}"

I have found documentation on an anchor property, but I don't believe it is applies to the one for spreadsheet comments. This is what I found: https://developers.google.com/drive/v3/web/manage-comments There is no description on how to interpret the value for the "range" key above. And other things that documentation describes are not present in my object.

Any ideas on how to interpret the above-mentioned range value? A pointer to any doc would be brilliant. I have indeed looked exhaustively, but must not be asking the right question because I cannot find any doc on this property. Guidance is very much appreciated.

解决方案

At this time, this it's not possible. Please star the feature request about this: Provide read/write access to comments in Google Sheets

Related Q&A

• Google Apps Script Spreadsheet Comment Automation
• Creating anchored comments programmatically in Google Docs

这篇关于在Google表格中查找评论的位置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！