Pivot table graph is displayed differently in the converted PDF file

Hi team,

The pivot table graph seems to display differently/incorrectly as compared to the original excel file from which it has been converted to.
We have attached the test file in the zip and steps how to create the original excel file.

Could you please check and confirm if this is a defect and any workaround to avoid this?

Thank you!

Regards,
John

test files.zip (454.1 KB)

@IDBSSupport,

Thanks for the template file and output PDF.

Please try using our latest version/fix: Aspose.Cells for Java v22.10 (Download | Maven). I have tested with the latest version by converting your template file to PDF and it works fine and as expected.

Let us know if you still find the issue with latest version/fix.

Dear ,

Thank you for contacting IDBS Support. This is an automated response to confirm receipt of your message. Your case has been logged with the following details:

Case Number: F0134649

Registered Date: 2022/11/08 10:45:40 GMT

Description of issue raised:

@IDBSSupport,

Thanks for the template file and output PDF.

Please try using our latest version/fix: Aspose.Cells for Java v22.10 (Download | Maven). I have tested with the latest version by converting your template file to PDF and it works fine and as expected.

Let us know if you still find the issue with latest version/fix.

@IDBSSupport,

Thanks for the post to confirm that you have received the reply we posted.

We tested with Aspose latest version, this issue still presents. Could you please investigate further into this?

@IDBSSupport
Pleas check 23.1.zip (25.0 KB)
generated by 23.1 with the following codes:

var wb = new Workbook(dir + "test file.xlsx");
PdfSaveOptions saveOptions = new PdfSaveOptions();
saveOptions.OnePagePerSheet = true;
wb.Save(dir + "23.1.pdf", saveOptions);

Dear ,

Thank you for contacting IDBS Support. This is an automated response to confirm receipt of your message. Your case has been logged with the following details:

Case Number: F0136224

Registered Date: 2023/01/25 11:31:37 GMT

Description of issue raised:

@IDBSSupport
Pleas check 23.1.zip (25.0 KB)
generated by 23.1 with the following codes:
var wb = new Workbook(dir + “test file.xlsx”);
PdfSaveOptions saveOptions = new PdfSaveOptions();
saveOptions.OnePagePerSheet = true;
wb.Save(dir + “23.1.pdf”, saveOptions);

@IDBSSupport,

Thanks for the post to confirm that you have received the reply with attachment we posted.

Our team has tested and confirmed that the issue persists- V23.4

Could you please check?

@Override
protected File convertToPDF() throws Exception
{
LoadOptions loadOptions = new LoadOptions();
loadOptions.setMemorySetting(MemorySetting.MEMORY_PREFERENCE);
Workbook workbook = new Workbook(inputFile.getAbsolutePath(), loadOptions);

    PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
    pdfSaveOptions.setOnePagePerSheet(NO_ONE_PAGE_PER_SHEET);
    pdfSaveOptions.setRefreshChartCache(true); // Having this as true causes the bug

    File resultedPdf = new File(inputFile.getAbsolutePath() + ".pdf");

    workbook.save(resultedPdf.getAbsolutePath(), pdfSaveOptions);
    return resultedPdf;
}`

This is part of the code snippet used to generate the PDF. A response is needed to the already current open Aspose support ticket mentioning the bug is due to “setRefreshChartCache” being true, if it is false the bug is not present.

@IDBSSupport
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-53218

@IDBSSupport,

We are pleased to inform you that your issue (previously documented as “CELLSNET-53218”) has been resolved. This fix will be included in our upcoming release (Aspose.Cells v23.5) scheduled in the first half of May 2023. You will be notified when the next version is released.

The issues you have found earlier (filed as CELLSNET-53218) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi

Thanks. The update that you have referenced here is for NET.
Could you please confirm if the same has been fixed in the JAVA version as well?

@IDBSSupport,

Please try latest Java version: Aspose.Cells for Java 23.5.