Aspose Cells: AutoFitRows cause wrong sheet render

Aspose.Cells Product Family
1

Hi support,

I’ve an issue with the AutoFitRows function. As you can see in the attached example, I obtain different results, before and after using this function. Some text became unreadable in the .png file when these properties are applied.

Thanks in advance.

2

There is the example.

3

Hi Andrea,


Thank you for sharing your code snippet & sample spreadsheet.

We have evaluated the presented scenario while using the latest version of Aspose.Cells for .NET 8.3.0.2, and we have noticed that calling the AutoFitRows before rendering the worksheet image format causes the text is getting cut-off from the top. We have logged this problem in our bug tracking system under the ticket CELLSNET-43201 for further investigation & correction purposes. Please spare us little time to properly isolate the problem cause, and to provide the fix at earliest possible. In the meanwhile, we will keep you posted with updates in this regard.

Please review the attached resultant images and let us know if you can find other discrepancies in the results.
4

Hi Andrea,


This is inform you that we have completed the investigation of the problem logged earlier as CELLSNET-43201. The problem is caused due to the reason that you are not setting the AutoFitterOptions.AutoFitMergedCells property to true in your code. Please modify the code as follow and give this scenario another try on your side.

C#

//Set auto fitter options
var AFOptions = new AutoFitterOptions();
AFOptions.OnlyAuto = true;
AFOptions.IgnoreHidden = true;
AFOptions.AutoFitMergedCells = true;

5

Thank you! Your suggestion solves our issue.

6

Hi Andrea,


Thank you for the confirmation. Please feel free to contact us back in case you need our further assistance with Aspose APIs.
7

The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan