Threaded comments

EPPlus supports threaded comments from version 5.3. With threaded comments users can add comments to a thread that belongs to a cell in a worksheet. The users can mention eachother in the comments and the entire thread can be resolved (closed/locked) and re-opened. EPPlus supports all of these features. Threaded comments exists in several spreadsheet programs, however the EPPlus implementation is designed to cover most of the functionality in Excel/Office 365.

Persons

When a user adds a threaded comment in Excel/Office 365 the user is added to a collection of Persons in the workbook. With EPPlus you can read/edit/delete these users, see code below.

var persons = package.Workbook.ThreadedCommentPersons;

You can add a new person this way:

var p1 = persons.Add("John Doe");
//This method call above is using default parameters same as below
var p2 = persons.Add("Jane Doe", "Jan Källman", IdentityProvider.NoProvider);

The Persons collection is also available via the worksheet, see code below.

var sheet = package.Workbook.Worksheets.First();
var author = sheet.ThreadedComments.Persons.First();

The Persons collection exposes functions for an indexer (numeric index and id (string)).

IdentityProvider enum This enum represent the for different sources that are supported:

• NoProvider - The person is not represented in a catalog outside the workbook
• ActiveDirectory - The person corresponds to an Active directory user. Person's userId should be an ActiveDirectory Security Identifier (SID).
• WindowsLiveId - The person corresponds to a Windows Live user. Person's userId should be a 64-bit signed decimal that uniquely identifies a user on Windows Live.
• Office365 - The person corresponds to an Office 365 user. The Person's userId should be a string that uniquely identifies a user. It SHOULD be comprised of three individual values separated by a "::" delimiter.
• PeoplePicker - The person corresponds to a People Picker user. The Persons userId should be an email address provided by People Picker.