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
Add a comment
Please log in or register to submit a comment.