We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Columns and row don't match when converting excel file to pdf

Hi,


We are still evaluating Aspose.cells. If we have an excel file with a pivot table and we convert it to PDF, the rows and columns will be in a different order than it shows in Microsoft Excel. Can you please test this and see if it is a bug?

Thanks.

Hi Edwin,

Thanks for your posting and using Aspose.Cells.

Please download and try the latest version: Aspose.Cells for Java 8.3.0 and see if it resolves your issue. Your problem should be fixed with it.

In case, your problem still persists, then please provide us your source Excel file containing your Pivot Table which you are converting to PDF. We will test this issue at our end and log it in our database if we found it as a bug.

I have downloaded 8.3.0 and tested it with attached xslx file but I am still seeing the same issue.


Expected: When doing print preview in excel that should be how the pdf should be.

Actual: In excel print preview, Fred comes before Steve but when using aspose, Steve will come before fred.

The rows are also in a different order. APAC is before NAM in excel but when using aspose, NAM will show before APAC.

Hi Edwin,

Thanks for your posting and using Aspose.Cells.

We were able to replicate this issue after executing the following sample code using the latest version: Aspose.Cells for Java 8.3.0. Columns and Rows of Pivot Table don’t match after converting Excel to PDF.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSJAVA-41099 - Columns and Rows of Pivot Table don’t match after converting Excel to PDF

I have also attached the output PDF generated with this sample code and screenshot highlighting this issue for a reference.

Java

String filePath = “F:\Shak-Data-RW\Downloads\testExcel.xlsx”;


Workbook workbook = new Workbook(filePath);


Worksheet worksheet = workbook.getWorksheets().get(“Sheet2”);


PivotTable pvt = worksheet.getPivotTables().get(0);


pvt.refreshData();

pvt.calculateData();


PdfSaveOptions opts = new PdfSaveOptions();

opts.setOnePagePerSheet(true);

workbook.save(filePath + “.out.pdf”, opts);

Hi Edwin,

Thanks for using Aspose.Cells.

We have fixed
this issue now. We will provide you a fix in couple of days after
incorporating other enhancements and fixes and conducting some extensive
testing. Once, it is available for you, we will let you know asap by
posting in this thread.

Hi,


<span style=“font-size:12.0pt;font-family:“Times New Roman”,“serif”;
mso-fareast-font-family:“Times New Roman”;mso-ansi-language:EN-SG;mso-fareast-language:
EN-SG;mso-bidi-language:AR-SA”>Please try our latest fix/version: Aspose.Cells
for Java v8.3.0.3
<span style=“font-size:12.0pt;font-family:“Times New Roman”,“serif”;
mso-fareast-font-family:“Times New Roman”;mso-ansi-language:EN-SG;mso-fareast-language:
EN-SG;mso-bidi-language:AR-SA”>
<span style=“font-size:12.0pt;font-family:“Times New Roman”,“serif”;
mso-fareast-font-family:“Times New Roman”;mso-ansi-language:EN-SG;mso-fareast-language:
EN-SG;mso-bidi-language:AR-SA”>We have fixed your issue.
<span style=“font-size:12.0pt;font-family:“Times New Roman”,“serif”;
mso-fareast-font-family:“Times New Roman”;mso-ansi-language:EN-SG;mso-fareast-language:
EN-SG;mso-bidi-language:AR-SA”>
<span style=“font-size:12.0pt;font-family:“Times New Roman”,“serif”;
mso-fareast-font-family:“Times New Roman”;mso-ansi-language:EN-SG;mso-fareast-language:
EN-SG;mso-bidi-language:AR-SA”>Let us know your feedback.
<span style=“font-size:12.0pt;font-family:“Times New Roman”,“serif”;
mso-fareast-font-family:“Times New Roman”;mso-ansi-language:EN-SG;mso-fareast-language:
EN-SG;mso-bidi-language:AR-SA”>
<span style=“font-size:12.0pt;font-family:“Times New Roman”,“serif”;
mso-fareast-font-family:“Times New Roman”;mso-ansi-language:EN-SG;mso-fareast-language:
EN-SG;mso-bidi-language:AR-SA”>Thank you.



The issues you have found earlier (filed as CELLSJAVA-41099) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.