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.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.