When I convert a file from FileFormatType.SpreadsheetML to FileFormatType.Excel97 using Aspose.Cells 4.0.1.0 the AutoFitHeight="1" row field seems to be ignored.
Opening the original XML file directly in Excel show the correct row sizing, but after conversion you can clearly see in the Dest.xls file that the sizing has been lost. I attached the sample Orig.xml file.
I created the file I wanted in Excel 2003 and did a Save As XML Spreadsheet. Then I used that file as a template to generate similar files with more data using XSLT. I also manually edited the AutoFitHeight property.
> try this workaround
It works for this particular case. But the piece of code I pasted is generic. I want specific rows to be autofitted and only in some files. So, if this is the only solution you have, I will have to parse the input xml and check which rows need to be autofitted.