We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

When converting Excel to Pdf AutoFitRow() does not work properly

When create Excel in which I use AutoFitRow() method. It works fine but when I convert this file to PDF (to be more specific, when I save workbook with SaveFormat.Pdf into stream. It makes AutoFitRow() to behave strangely - the rows I use AutoFitRow() for are too stretched , they are much higher then they should be and it. It even seems that the height grows exponentially to the lenght of the text for which I am trying to fit that row.

@Bunnykill,
Thank you for your query.
Please share your Template Excel file, output PDF file and runnable console application which can be used to reproduce this issue here. We will test the scenario and provide feedback at the earliest.

It seems like I have fixed the problem myself.

Instead of calling AutoFitRow() method in foreach() and with parameter of a row.
I used with it’s startRow and endRow parameters for a whole set of rows I need to Autofit.

@Bunnykill,
Thank you for providing the feedback and glad to know that your issue is sorted out. Please feel free to write us back if you have any other query related to Aspose.Cells.