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

Free Support Forum - aspose.com

Comment.Autosize property does not seem to work

Setting the autosize property on a comment does not have any effect.


Shane Parker

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

Please try the attached latest version of Aspose.Cells. I tested your scenario with it and it works fine. If you still face any problem, please share the sample code and template file here. We will check it soon.

Thank You & Best Regards,

I tried with your version 4.9 dll, but it does not seem to make a difference. See my sample code below:

Imports Aspose.Cells
Module Module1

Sub Main()

Dim book As New Workbook
Dim sheet As Worksheet = book.Worksheets(0)

sheet.Comments.Add(1, 1)

sheet.Comments(0).AutoSize = True
sheet.Comments(0).Note = “Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.”

book.Save(“C:\COMMENT_TEST.xlsx”, Aspose.Cells.FileFormatType.Excel2007Xlsx)

End Sub

End Module

Please let me know if I am doing something wrong.



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

Thank you for sharing the sample code.

We have found your mentioned issue after an initial test. Your issue has been registered in our internal issue tracking system with issue id: CELLSNET-17306. We will look into it and get back to you soon.

Thank You & Best Regards,


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

Please try the attached latest version of Aspose.Cells. We have fixed your mentioned issue.

Thank You & Best Regards,

The issues you have found earlier (filed as 17306) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.

While trying to keep the API as straightforward and clear as possible, we have decided to recognize and honor the common development practices of the platform; we have re-arranged API Structure/ Namespaces.

With this release, we have reorganized the API classes for Aspose.Cells component. This change has some major aspects that we follow. We have added new namespaces. The entire API (classes, interfaces, enumerations, structures etc.) were previously located in the Aspose.Cells namespace. Now, certain sets of API have been moved to their relative namespaces, which make the relationship of classes (with their members) and namespaces clear and simplified. It is to be noted here, we have not renamed existing API (classes, enumerations etc.) but, I am afraid you still need to make certain adjustments in your existing projects accordingly.

For complete reference, please see the product's API Reference.