Auto fit rows for wrapped text - EPM

[former_member603036]

I have an EPM report that brings in fairly long comments in a column - I've formatted the column on the Formatting Sheet to wrap the text. However, every time the report is refreshed, the row height adjusts to being too small to see all of the text. is there a way to set the rows to auto fit the resulting text?

Thanks in advance.

[ragunathan1985]

Is your issue resolved. I also face the same issue.

[former_member30]

Hi Ragunathan,
We have a very new function in the community, that says "I have a similar question".
You can see it directly under the question. If you hit that button, you will be informed, when the questions has been resolved 😉
Best regards,
Julia
SAP Community Moderator

[former_member603036]

Please also note that the comment field is not an imputable field, but just retrieving a comment using the EPMCommentFullContext function.

Thanks

[former_member603036]

Simply this:

Before refreshing the report, you can see the row height accommodates the size of the wrapped comment:

After refreshing, you can see the row height reduces in size so it doesn't show the entire comment:

Is there a way to format the report so the row height adjusts it's size to accommodate the size of the comment saved to the database.

Thanks in advance.

[ragunathan1985]

We could use VBA logic for Rows / Columns -> Rows("204:280").AutoFit

[former_member186338]

Full info with screenshots is required!