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[1];
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.
Thank you,
Tom
Official response
Hi,
This feature request has been implemented and is available in the latest versions of GemBox.Spreadsheet.
Regards,
Mario