Wrong cell formating when importing an Excel-file

Aspose.Cells Product Family
1

I’ve added both the base-xls file as well as my resulting output-pdf. As you can see, a lot of the formating went wrong (e.g. many cell-heights weren’t applied). Did I something wrong?
(docname == VeryBadBigFile.xls, outFileName = BigBad.pdf)

Aspose.Cells.Workbook docxls = new Workbook();
docxls.LoadData(docname);
MemoryStream docstream = new MemoryStream();
docxls.Save(docstream, FileFormatType.AsposePdf);
Aspose.Pdf.Pdf docPdf = new Pdf();
docPdf.BindXML(docstream, null);
docPdf.CompressionLevel = 9;
docPdf.Save(outFileName);

2

(here the resulting output file)

3

Hi,

Thanks for considering Aspose.

Please try the attached version

Thank you.

4

Hi,

Please change your codes:

Aspose.Cells.Workbook docxls = new Workbook();
docxls.Open(docname);

If you use LoadData, we don't load the page setup info.

We find a problem in Cell "F2" in the Worksheet "Workpackages". We will fix it soon.

Could you give us a list of error formatting.

5

Thanks for the help, we didn’t find any other error than the one you mentioned. (a wrong displayed date)

6

Please try this attached fix.

To get a correct date, please call Workbook.CalculateFormula method just before you call Workbook.Save method.