AutoFitRows and Manual Column Width Collapse

We are setting the column width for an report by deciding both column data and row data.We set the column width manually and autoFitRows for all the columns.

Somehow if the data is (5 lines or more) in a particular cell the data prints with "#########".After clicking the cell it's fine.How to resolve this issue.

Any resolution for this issue is much appreciated.

Thanks

Joe

Hi Joe,

If the column with is not less than the width of the cell value, "#" will be printed. Please make sure that whether column with is less than the width of the cell value. If column with is greater than the width of the cell,please post your sample file. We will check it soon.

Hi,

Please look at this file at Column Name "Client".The format is Text format.Don't know what exactly needs to be done here.Because the column width is already greater or equal to the longest text cell width contents.

I use wraptext for the long text column cells.The column width is calculated based on the longest cell data of the column.

Let me know your feedback.

Thanks a lot

Joe

Hi Joe,

If you apply the format to the cell and the width of cell string value is greater than the column width , MS Excel will show "#" not the cell value.

So please do not set any format for the cell, it will work fine.