The iterative calculation of Excel formulas converted to HTML through the ASPose interface yields incorrect results

Aspose.Cells Product Family
1

The iterative calculation of Excel formulas converted to HTML through the ASPose interface yields incorrect results
image.png (72.1 KB)
image.png (65.1 KB)

this is my code

Workbook workbook = new Workbook("D:\\Persinal_WorkSpace\\Aspose\\AposeTest\\src\\data\\EPPR-86563\\EPPR-86563.xlsx");
			workbook.getSettings().setIteration(true);
			workbook.getSettings().setMaxIteration(1000);
			workbook.getSettings().setMaxChange(0.001);
			workbook.calculateFormula();
			workbook.save("D:\\Persinal_WorkSpace\\Aspose\\AposeTest\\src\\data\\EPPR-86563\\EPPR-86563.html");

this is my fileļ¼š
EPPR-86563.zip (337.6 KB)

2

@xhaixia,

It seems your Excel file has external links for data source. I opened your Excel file into MS Excel manually and found it too gives same display as per your output HTML.
sc_shot1.png (196.4 KB)

3

@xhaixia
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSJAVA-46104

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

4

@xhaixia
It is very strange that when we re-evaluate your file, we can only get #N/A for those specified cells in ms excel now. Even if we change the date to 8/27/2024 we cannot get them be calculated as other value than #N/A in ms excel.
Would you please try the file in ms excel again at your end to see whether you can get the expected values now?