47
Views
4
Comments
Solved
[Advanced Excel] Comment_Add Autofit parameter does not work
Question
advanced-excel
Service icon
Forge asset by Carlos Freitas
Application Type
Service

When I add Comments in a sheet I set Autofit to True (which is the default in fact) it does not seem to work.

The vertical size seems to be fixed. The comment is cropped if there more than a few lines.

The horizontal size seems  randomly chosen to me. Sometimes lines are wrapped, sometimes there is a lot of whit space

Is this a known issue?

2025-09-25 22-50-38
Hanno
Solution

Hi @Rogier Olde Dubbelink

I wasn't able to recreate the issue you presented, even using your .oap provided.

I have however updated the code to explicitly apply the AutoFit setting to a comment.

Let me know if this resolves your issue.

Hanno

2020-09-04 11-39-50
Rogier Olde Dubbelink

Hi Hanno,

Yes, this did it.

Thank you so much for fixing it!

Before update component:

After update component :


UserImage.jpg
Saicharan Bondili

Hey , can you please post the screenshot of the sheet / issue?

2020-09-04 11-39-50
Rogier Olde Dubbelink

Comment looks like this:


but should be this (now resized manually):

Please find attached a small application to test.

Excel test comment.oap
2025-09-25 22-50-38
Hanno
Solution

Hi @Rogier Olde Dubbelink

I wasn't able to recreate the issue you presented, even using your .oap provided.

I have however updated the code to explicitly apply the AutoFit setting to a comment.

Let me know if this resolves your issue.

Hanno

2020-09-04 11-39-50
Rogier Olde Dubbelink

Hi Hanno,

Yes, this did it.

Thank you so much for fixing it!

Before update component:

After update component :


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.