Skip to main content linkedinfacebooktwittermenuarrow-up

Support for ExcelComment.Parent property Completed

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,


Official response

Mario at GemBox


This feature request has been implemented and is available in the latest versions of GemBox.Spreadsheet.