Hello,
Were trying to integrate the Aspose.Excel comment to retrieve the cells between to comments.
Sometimes it returns the correct row and column and sometimes it doesnt, retrieves a complemtly different comment or sometimes referencing a cell which contains no comment.
If you look at the sample sheet i have sent you
Cell D29 contains a comment saying ‘End(Geograhical Exposure)’.
However the comment object returns cell B74. This is happening to a lot of comments.
Rgds
Darren
This bug is fixed. Please download v2.8.8.4 at
@theMadLad,
Aspose.Cells has replaced Aspose.Excel which is discontinued now. This new product provides rich features to work with comments and Threaded Comments. Following example can be used to access the comments in a worksheet and display cell reference.
// Instantiate a Workbook
Workbook workbook = new Workbook();
// Get a reference of comments collection with the first sheet
CommentCollection comments = workbook.Worksheets[0].Comments;
// Add a comment to cell A1
int commentIndex = comments.Add(0, 0);
Comment comment = comments[commentIndex];
comment.Note = "First note.";
comment.Font.Name = "Times New Roman";
// Load an image into stream
Bitmap bmp = new Bitmap("logo.png");
MemoryStream ms = new MemoryStream();
bmp.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
// Set image data to the shape associated with the comment
comment.CommentShape.Fill.ImageData = ms.ToArray();
commentIndex = comments.Add(3, 0);
comment = comments[commentIndex];
comment.Note = "Second note.";
comment.Font.Name = "Times New Roman";
foreach(var item in workbook.Worksheets[0].Comments)
{
Console.WriteLine(CellsHelper.CellIndexToName(item.Row,item.Column));
}
// Save the workbook
workbook.Save("book1.out.xlsx", Aspose.Cells.SaveFormat.Xlsx);
Here are the links to the documents having detailed information about working with Comments and threaded comments.
Managing Comments
Threaded Comments
Get a free trial version here to test the product features:
Aspose.Cells for .NET (Latest Version)
Here is the link to a complete solution that contains a variety of examples to demonstrate different features of Aspose.Cells.
