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
@simon.zhao
First of all, thanks for the info!
We tried to reproduce the reported problem with version 21.4 and on that occasion we noticed that the content is consistent, but that its formatting is not the same.
Specifically the content of the source document (left in the attached picture) is written in Geneva Font and its size is 9, while the target document has the same Font but size 10,3.
v 21.4.PNG (11.6 KB)
@zpredojevic,
We have observed the difference in fonts and logged it with the ticket for further analysis. We will write back here once any update is ready for sharing.
@simon.zhao
We checked the fix. It works fine. Thanks.
@zpredojevic,
It is nice to know that your issue is resolved by the new fix. In the event of further queries or comments, feel free to write us back.
The issues you have found earlier (filed as CELLSJAVA-43486) have been fixed in this update.