Function LINEST calculate wrong result

Aspose.Cells Product Family
1
Workbook wb = new Workbook("C:/A.xlsx");
wb.calculateFormula();
wb.save("C:/A.html");


Cells include function LINEST (W4-W15 AA4-AA15 etc.) get a wrong result in html
2

Hi,

Thanks for your posting and using Aspose.Cells.

We have tested your issue with your sample code and source excel file using the latest version: Aspose.Cells for Java v8.9.1.1 and found that calculation of LINEST function is wrong as per your description.

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-41954 - Calculation of LINEST function is wrong

3

The issues you have found earlier (filed as CELLSJAVA-41954) have been fixed in Aspose.Cells for Java 26.6.