The formula in Excel cannot be displayed correctly when converted to HTML using workbook. calculateFormula()

Aspose.Cells Product Family
1

The formula in Excel cannot be displayed correctly when converted to HTML using workbook. calculateFormula()
this is my excel：
EPPR_95082.zip (29.1 KB)
image.png (23.9 KB)

this is html：
image.png (5.3 KB)

this is my code：

Workbook workbook = new Workbook(“D:\Persinal_WorkSpace\Aspose\AposeTest\src\data\EPPR_95082\EPPR_95082.xlsx”);
workbook.calculateFormula();
workbook.save(“D:\Persinal_WorkSpace\Aspose\AposeTest\src\data\EPPR_95082\EPPR_95082.html”);

2

@xhaixia
We can obtain the correct results by testing on the latest version v24.12 using the following sample code and sample files. Please refer to the attachment. result.zip (10.0 KB)

Workbook workbook = new Workbook(filePath + "EPPR_95082.xlsx");
workbook.calculateFormula();
workbook.save(filePath + "out_java.html");

We recommend you to kindly try using our latest version:
Aspose.Cells for Java 24.12.