Free Support Forum - aspose.com

Aspose Cells ignores inverted y-axis in diagram

Hi,
It seems that diagrams in xlsx spreadsheets with an inverted y axis are saved as if the axis was not inverted.

You can investigate with the following example code and the shared file document.xlsx:

final Workbook export = new Workbook(new FileInputStream("document.xlsx"), new LoadOptions());
final SaveOptions saveOptions = new PdfSaveOptions();
export.save(new FileOutputStream("/tmp/output.pdf"), saveOptions);

Expected outcome: The y-axis of diagram in output.pdf should be inverted like in document.xlsx.

Actual outcome: The y-axis is not inverted in output.pdf.

You can find document.xlsx at https://orgav.sharepoint.com/:x:/s/devops/ERrFjivhHm5IgsyXXoy_ikMBAx6Gk-VBpZGtzfMfNy8Xeg?e=T4Acp7.

@orgavision,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSJAVA-43436 - Aspose Cells ignores inverted y-axis in diagram
1 Like

@orgavision ,
The issues you have found earlier (filed as CELLSJAVA-43436) have been fixed in this update.

@Eric.wang @ahsaniqbalsidiqui Aspose Cells 21.4 for Java still has the issue. I’m providing an updated document which has an inverted y-axis https://orgav.sharepoint.com/:x:/s/devops/EX10mPUQXq5DncVihB8DOtkB7bIxb5aarlw3ToenAaL4Yw?e=PkADVL for you to reproduce the issue with the code sample above. I’m sorry the initial document didn’t have an inverted y-axis, my bad. However, inverted y-axis are not respected in excel-to-pdf export.

@orgavision,
We have noted your feedback and will share our comments after detailed analysis.

This is still an issue with Aspose Cells 21.5.

@orgavision,
We have noted your concern and logged it with the ticket for further analysis using the latest version. You will be notified here once any update is ready for sharing.

Hi @orgavision,


This link is invalid, could you please provide the document again?

aspose-excel-difference.zip (109.0 KB)
Now if found the button to upload something. The archive contains the same as the link which you can disregard. Please let me know if you need any more information and whether you can reproduce the issue. Thanks for having a look.

@orgavision,
Thank you for the sample document. We will analyze it and share our feedback soon.

@orgavision ,
We found it works ok with Aspose Cells 21.5.
Could you please provide the issue output file?