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

Free Support Forum - aspose.com

How do I get cell to auto expand based on the data?

Hi Team,


In Aspose 8.3.4,We are unable to see the values in excel column(Total,SFR,SET) and its not expanding the cell properly.Can you please suggest me the solution to resolve the problem?I have attached the excel screen shot which is having the same issue.

Hi Saravanan,


Thank you for sharing the snapshot.

Are you talking about the values being displayed as #####. If yes, please call the Worksheet.AutoFitColumns method just before saving the spreadsheet to file. It should resolve the problem. In case the problem persists, please give a try to the latest version of the Aspose.Cells for .NET 8.6.3.2 to make sure there isn’t bug in your current revision of the API for this feature.