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

edwin.he · November 20, 2014, 5:41pm

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.

shakeel.faiz · November 20, 2014, 10:00pm

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.

edwin.he · November 21, 2014, 9:47am

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.

shakeel.faiz · November 21, 2014, 10:58am

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);

shakeel.faiz · December 1, 2014, 9:51pm

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.

amjad.sahi · December 3, 2014, 1:14am

Hi,

Please try our latest fix/version: Aspose.Cells
for Java v8.3.0.3

We have fixed your issue.

Let us know your feedback.

Thank you.

aspose.notifier · December 11, 2014, 4:13am

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.