Thanks for your posting and using Aspose.Cells.
We were able to observe this issue using the latest version Aspose.Cells
for Java v22.214.171.124 with the following sample code and found date calculation is wrong.
We have logged this issue in our database for investigation. We will look into it and fix this issue. Once the issue is resolved or we have some other update for you, we will let you know asap.
This issue has been logged as
- CELLSJAVA-41474 - Date calculation is wrong
I also used the Workbook.calculateFormula() but it did not change the results.
String filePath = “F:/Shak-Data-RW/Downloads/s.xlsx”;
Workbook wb = new Workbook(filePath);
wb.save(filePath + “.out.html”);