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
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
Actual outcome: The y-axis is not inverted in
You can find
document.xlsx at https://orgav.sharepoint.com/:x:/s/devops/ERrFjivhHm5IgsyXXoy_ikMBAx6Gk-VBpZGtzfMfNy8Xeg?e=T4Acp7.