Class ThreadedComment
Represents a single comment in a threaded comment conversation on a worksheet cell.
Inherited Members
Namespace: DRIT.Spreadsheet
Assembly: DRIT.Spreadsheet.dll
Syntax
public sealed class ThreadedCommentRemarks
Threaded comments are the modern Excel 365 comment model ("Review > New Comment").
They are stored in the xl/threadedComments/*.xml parts and differ from the
legacy cell notes represented by Comment. A threaded comment can be a
top-level comment or a reply to another threaded comment via Parent.
Constructors
ThreadedComment(Worksheet)
Creates a new threaded comment belonging to the specified worksheet.
Declaration
public ThreadedComment(Worksheet worksheet)Parameters
| Type | Name | Description |
|---|---|---|
| Worksheet | worksheet |
Remarks
Threaded comments are the modern Excel 365 comment model ("Review > New Comment").
They are stored in the xl/threadedComments/*.xml parts and differ from the
legacy cell notes represented by Comment. A threaded comment can be a
top-level comment or a reply to another threaded comment via Parent.
Properties
Author
Specifies the author of the comment.
Declaration
public ThreadedCommentAuthor Author { get; set; }Property Value
| Type | Description |
|---|---|
| ThreadedCommentAuthor |
Remarks
Threaded comments are the modern Excel 365 comment model ("Review > New Comment").
They are stored in the xl/threadedComments/*.xml parts and differ from the
legacy cell notes represented by Comment. A threaded comment can be a
top-level comment or a reply to another threaded comment via Parent.
CellRef
Specifies the cell reference (e.g. "A1") the comment is anchored to.
Declaration
public string CellRef { get; set; }Property Value
| Type | Description |
|---|---|
| string |
Remarks
Threaded comments are the modern Excel 365 comment model ("Review > New Comment").
They are stored in the xl/threadedComments/*.xml parts and differ from the
legacy cell notes represented by Comment. A threaded comment can be a
top-level comment or a reply to another threaded comment via Parent.
CreatedTime
Specifies the date and time when the comment was created.
Declaration
public DateTime CreatedTime { get; set; }Property Value
| Type | Description |
|---|---|
| DateTime |
Remarks
Threaded comments are the modern Excel 365 comment model ("Review > New Comment").
They are stored in the xl/threadedComments/*.xml parts and differ from the
legacy cell notes represented by Comment. A threaded comment can be a
top-level comment or a reply to another threaded comment via Parent.
Done
Indicates whether the comment thread is resolved (done).
Declaration
public bool Done { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
Remarks
Threaded comments are the modern Excel 365 comment model ("Review > New Comment").
They are stored in the xl/threadedComments/*.xml parts and differ from the
legacy cell notes represented by Comment. A threaded comment can be a
top-level comment or a reply to another threaded comment via Parent.
Id
Specifies the unique identifier (a GUID string) for this comment.
Declaration
public string Id { get; set; }Property Value
| Type | Description |
|---|---|
| string |
Remarks
Threaded comments are the modern Excel 365 comment model ("Review > New Comment").
They are stored in the xl/threadedComments/*.xml parts and differ from the
legacy cell notes represented by Comment. A threaded comment can be a
top-level comment or a reply to another threaded comment via Parent.
Parent
Specifies the parent comment when this comment is a reply;
null for a top-level comment.
Declaration
public ThreadedComment Parent { get; set; }Property Value
| Type | Description |
|---|---|
| ThreadedComment |
Remarks
Threaded comments are the modern Excel 365 comment model ("Review > New Comment").
They are stored in the xl/threadedComments/*.xml parts and differ from the
legacy cell notes represented by Comment. A threaded comment can be a
top-level comment or a reply to another threaded comment via Parent.
Text
Specifies the plain text content of the comment.
Declaration
public string Text { get; set; }Property Value
| Type | Description |
|---|---|
| string |
Remarks
Threaded comments are the modern Excel 365 comment model ("Review > New Comment").
They are stored in the xl/threadedComments/*.xml parts and differ from the
legacy cell notes represented by Comment. A threaded comment can be a
top-level comment or a reply to another threaded comment via Parent.
Worksheet
Gets the worksheet that contains this threaded comment.
Declaration
public Worksheet Worksheet { get; }Property Value
| Type | Description |
|---|---|
| Worksheet |
Remarks
Threaded comments are the modern Excel 365 comment model ("Review > New Comment").
They are stored in the xl/threadedComments/*.xml parts and differ from the
legacy cell notes represented by Comment. A threaded comment can be a
top-level comment or a reply to another threaded comment via Parent.
Methods
Resolve()
Marks this comment thread as resolved.
Declaration
public void Resolve()Remarks
Threaded comments are the modern Excel 365 comment model ("Review > New Comment").
They are stored in the xl/threadedComments/*.xml parts and differ from the
legacy cell notes represented by Comment. A threaded comment can be a
top-level comment or a reply to another threaded comment via Parent.
Unresolve()
Marks this comment thread as unresolved (not done).
Declaration
public void Unresolve()