We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Aspose.Cells cell Comment with Picture

In Excel you can set a comment by righ clicking border Format -> Color and Lines -> Fill Color then click Fill Effects... then click Picture. You can now browse to a picture and insert it. Now when the mouse is over the comment indicator in the cell the image pops up.

My question is this. Is there a way to do that using Aspose.Cells?

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

I am afraid your requested feature is not support with Aspose.Cells at the moment. We have added your feature request into our internal issue tracking system with issue id: CELLSNET-16847. We will look into it and get back to you soon.

Thank You & Best Regards,

Hi,


Please try the new fix 4.9.1.4 (attached). We have support to set picture as fill format of the shape.

Please try the following code:


Workbook workbook = new Workbook();

Comments comments = workbook.Worksheets[0].Comments;

comments.Add("B3");

Comment comment = comments[0];

byte[] imageData = File.ReadAllBytes(@"F:\FileTemp\book2.png");

comment.CommentShape.FillFormat.ImageData = imageData;

<span style=“font-family: “Calibri”,“sans-serif”;”>
workbook.Save(@“F:\FileTemp\dest.xls”);


<span style=“font-size: 11pt; font-family: “Calibri”,“sans-serif”; color: rgb(31, 73, 125);”>Thank you.