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.