Skip to main content facebooktwittermenuarrow-up

Support for ExcelComment.Parent property - Community / GemBox.Spreadsheet Feature Request - GemBox Support Center

4

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,

Tom

Official response

Mario at GemBox

Hi,

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

Regards,
Mario