2020-09-04 11-39-50
Rogier Olde Dubbelink
30Views
4Comments
Solved
[Advanced Excel] Comment_Add Autofit parameter does not work
Question
Forge
Service
advanced-excel
Service icon
Advanced Excel
Forge component 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?

0
0
10 Jul
2022-07-06 03-36-19
Hanno
 
MVP
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

See solution in context
0
0
22 Oct

Hi Hanno,

Yes, this did it.

Thank you so much for fixing it!

Before update component:

After update component :


2
0
23 Oct

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

0
0
10 Jul

Comment looks like this:


but should be this (now resized manually):

Please find attached a small application to test.

Excel test comment.oap
0
0
10 Jul
2022-07-06 03-36-19
Hanno
 
MVP
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

0
0
22 Oct

Hi Hanno,

Yes, this did it.

Thank you so much for fixing it!

Before update component:

After update component :


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