Free Support Forum - aspose.com

Fit the columns and rows

Hi Team,

I cant make to fit the column and rows if i use merge in the excel. I have attached the excel which contains the issue. Please look it and let me give any idea to do.

I tried Autofitcolumns and Autofitrows.

Hi,

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

We were able to replicate this issue using the latest version:
Aspose.Cells
for .NET v7.3.2.2
.

Please see the sample test code. I have also attached the output xlsx file and the screenshot showing the comparison between source and output xlsx files for your reference.

We have logged this issue in our database. We will look into this issue and fix it. Once the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-41124.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\Test.xlsx”;


Workbook workbook = new Workbook(filePath);


Worksheet worksheet = workbook.Worksheets[0];


//Autofit columns does not work

worksheet.AutoFitColumns();

worksheet.AutoFitRows();


workbook.Save(filePath + “.out.xlsx”);

Screenshot:

Hi,


Please try this fix/version: Aspose.Cells for .NET v7.3.2.3

We have fixed your issue.



The issues you have found earlier (filed as CELLSNET-41124) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by aspose.notifier.