Excel Wrapping the Merged cells

Aspose.Cells Product Family
1

I am using an excel to display contents from a database, which is needed to convert into PDF. In excel am not able to see the whole contents after wrapping the merged cells. If I click on the particlar cell the whole contents are dsiplayed, But in Pdf it wont work out. I am wrappig the content by

bodyStyle.Iswrapped=true and after that am merging the same.But the issue mentioned above is happening,

Please advice us ASAP

2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Please download and use the latest version:
Aspose.Cells
for .NET v7.2.2.1
and see if it resolved your problem.

If the problem still occurs, then please provide us your source xls/xlsx file and the code replicating the problem.

We will look into it and help you asap.

Also you can try autofitting rows and columns using the worksheet.AutoFitColumns() and worksheet.AutoFitRows() methods.

3

Hi,


We also recommend you to kindly see the document:
http://www.aspose.com/docs/display/cellsnet/AutoFit+Rows+and+Columns


Note: Please see the contents/example under the sub-heading: "AutoFit Rows for Merged Cells" for your complete reference on how to auto-fit rows on merged cells with text wrapping on.

Thank you.