BESSELI function incorrectly calculated

Aspose.Cells Product Family
1

Hi,

Please use the attached file and the following code for reproducing this issue - BESSELI function is not returning the same result like in Excel.

var workbook = new Workbook(“Engineering.xlsx”);

Console.WriteLine(“C3 StringValue: {0}”, workbook.Worksheets[1].Cells[“C3”].StringValue);
Console.WriteLine(“C3 Value: {0}”, workbook.Worksheets[1].Cells[“C3”].Value);

workbook.CalculateFormula();

Console.WriteLine(“C3 StringValue: {0}”, workbook.Worksheets[1].Cells[“C3”].StringValue);
Console.WriteLine(“C3 Value: {0}”, workbook.Worksheets[1].Cells[“C3”].Value);

Console.ReadKey();

A fix is needed for consistent result after opening the file and after calling CalculateFormula. Also, the result should be consistent with the result from Excel (cell’s Value and Value2 in MS Excel).

Thank you,
Aurelian Iordache
IBM Romania

2

Hi Aurelian,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue using the latest version: Aspose.Cells for .NET 8.0.0 with your sample code and source file. There is a little difference between Aspose.Cells calculated value and MS-Excel calculated value.

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 CELLSNET-42512.

Console Output:
C3 StringValue: 0.981666428
C3 Value: 0.981666428475166
C3 StringValue: 0.981666429
C3 Value: 0.981666428868382

3

Hi Aurelian,

Thanks for using Aspose.Cells.

We have looked into this issue further and found this is a precision issue.

We tried different tools and get different
results.

Aspose.Cells 0.981666428868382
MS
Excel 0.981444428475166
MATLAB 0.98166642857791
OpenOffice 0.981666428577391


1) Except the result of MS Excel, all display string value will be
0.981666429.

2) We could not know which result is the best and how MS
Excel and MATLAB implement this function .

3) The result is different
from the tenth decimal. We think the precision of Aspose.Cells is enough. Do
you still need to improve it?