AutoFitRow(s) don't work with some styles

Aspose.Cells Product Family
1

Hi,

I want to tell another problem that has occurred when I update Aspose Cells from 4.4.0.0 to 5.2.2.

In version 4.4.0.0 I used the code in attchment to export data into Excel, and the result was correct.

Updating to version 5.2.2, all rows containing a date field evaluated, results with an height higher than expected. I noticed that if I set the font to “Arial” or if I delete the seconds format of datetime fields, the AutoFitRow working properly.

Best regards

2

Hi,

Please try the attached latest version/fix v5.2.2.1 in which we have enhanced the AutoFitRow operation.
If you still find the issue, kindly do post the generated Excel file here, we will try the function upon your template file to figure your issue out soon.

By the way, in the new versions, we have modified the style formatting model for performance considerations, so if you need to apply some formatting to the range or row, you should use Range.ApplyStyle() method, Similarly, you may use Row/Column.ApplyStyle() method etc.

For complete reference, see the documentation, e.g
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/named-ranges.html

http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/approaches-to-format-data-in-cells.html
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/formatting-rows-columns.html

thank you.

3

Hi,

I tried this version and the problem seems solved.

Thanks