Free Support Forum - aspose.com

Chart content mismatch (2605)

Hi,

I am writing to you about a problem we encountered in working with MSO Excel documents using the Aspose Cells for Java 20.10.0 library.

In particular, when we load an Excel document whose format is “.xls” and immediately (without any changes) save it (same format - “.xls”), it appears that the charts on the source and target document (sheetname “Chart1”) is not the same (take a look at the horizontal axis and the content of the legend).

I am enclosing the zip file with source code, as well as the source and target Excel files.

In the hope that together we will quickly overcome the problem!

Best regards!
Nenad

Source code and XLS files.zip (44.4 KB)

@zpredojevic,

We were able to reproduce the issue as you mentioned by re-saving your template file via Aspose.Cells APIs. We found horizontal and legend entries are not rendered the same way (as in the template file) in the output XLS file:
e.g.
Sample code:

String excelSourceFilePath = "f:\\files\\chart_mismatch.xls";
String excelTargetFilePath = "f:\\files\\chart_mismatch-done.xls";
Workbook excelWBNotChanged = new Workbook (excelSourceFilePath);
excelWBNotChanged.save(excelTargetFilePath, SaveFormat.EXCEL_97_TO_2003);

We have logged a ticket with an id “CELLSJAVA-43432” for your issue. We will look into it soon.
Once we have an update on it, we will let you know here.

@Amjad_Sahi,

Thanks for the quick response! We stay in touch.

Best regards!
Nenad

@zpredojevic,
You are welcome.

@zpredojevic,

This is to inform you that your issue has been resolved now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

@zpredojevic
Please try our latest version/fix: Aspose.Cells for Java v21.3.8 (attached)
aspose-cells-21.3.8-java.zip

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