I try to see if changing forum sombody has an answer.

I'm working on a report produced with excel and I have 2 problems with autofit and wrap text.
First of all I need to use autofit on a range of 5 merged cells. I know that it doesn't work so I have a column on the right of the print area with a formula to display the same text.
Cells in this column has the same exact format of those in the merged range.
I set the width of this column as the sum of the width of the 5 columns in the report and, surprise, merged cells can contain more characters on a single line then the single one.

The second problem is specific of autofit option.
It often happen that autofit allocate two lines even if the text is displayed in a single line and this leave unwanted empty lines in my report.

Does anybody knows if it is possible to solve these two problems?