Please could you add a property or method to the
ExcelComment class, to provide the parent
ExcelCell instance the comment is on?
When you iterate through the
ExcelCommentCollection it's not easy to find which parent cell the comment came from.
The following is a way of doing this (as provided by GemBox support) as a workaround:
var comment = worksheet.Comments;
var cell = worksheet.Rows.SelectMany(r => r.AllocatedCells).First(c => c.Comment == comment);
But it would be much nicer/cleaner to have a property/method directory on the
ExcelComment instance itself.
This feature request has been implemented and is available in the latest versions of GemBox.Spreadsheet.