Several Aspose formula calculation issues

Aspose.Cells Product Family
1

Hello,

We’ve encountered several issues with Excel formula calculation, when performing Workbook.CalculateFormula(…), we’ve noticed some differences between Aspose calculation and Excel calculation.

We’ve attached two files with the formulas being tested. In the test files there are three columns:
- Formula (formula being tested)
- Expected Value - the value as given by Excel
- Aspose Value - the value as given by Aspose when performing Workbook.CalculateFormula() over the excel file

From the FormulaTestFile1.xls file, the GCD function seems to not be calculated correctly by Aspose:
Formula Excel Value Aspose Value
GCD 12 0

From the FormulaTestFile2.xlsx file, the CONVERT, BESSELI, BESSELK, BESSELY, ERF, ERFC, IMLOG2 functios seems to not be calculated correctly by Aspose:
Formula Excel Value Aspose Value
CONVERT 20 68
BESSELI 0.981666428475166 0.981666428868382
BESSELJ 0.329925828669785 0.329925828669785
BESSELK 0.277387803632259 0.277387803519138
BESSELY 0.145918137508313 0.145918137506499
ERF 0.707928693148820 0.707928920095738
ERFC 0.157299264825445 0.157299207050285
IMLOG2 2.32192809506607+1.33780421255394i 2.32192809488736+1.33780421245098i

Please investigate these issues and provide us some feedback.

Thanks in advance,
Mihai Andrei,
Sr. Software Engineer,
IBM Romania

2

Hi Mihai,


Thank you for using Aspose.Cells.

We will look into the issues you have mentioned and provide feedback as soon as possible. If it’s a bug at Aspose.Cells end, we will log it into our database for further investigation and rectification by our development team.
3

Hi,

Thank you for using Aspose Cells.

After an initial investigation, I was able to reproduce/observe the issues as you have mentioned with the following lines of code. I have forwarded this information to our development team for further investigation and resolution.

We will let you know here once we have an update from our development team regarding the resolution of this issue. The issue has been logged in our issue tracking system as CELLSNET-40860.

ibmromania:

Formula Excel Value Aspose Value
CONVERT 20 68

The CONVERT function is not yet supported by the current version of Aspose.Cells, as you can see in the list of Non-Supported formulas.

Workbook workbook = new Workbook("K://FormulaTestFile2.xlsx");
workbook.CalculateFormula();
workbook.Settings.CalcMode = CalcModeType.Manual;
workbook.Save("K://FormulaTestFile2Out.xlsx");
4

Hi,

Please download and try this fix: Aspose.Cells for .NET

v7.3.0.1

a) TestFile1.xls file

We have fixed the issue of the GCD function.

b)
FormulaTestFile2.xlsx file

We have fixed the issue of CONVERT function.

We
could not fix the issue of the precision of other Engineering functions, we will fix them soon

5

Hello,

We’ve tested the CONVERT function, seems ok.

Regarding the precision for the other Engineering functions, do you have an estimate for their resolution ?

I’ve attached another excel with engineering test functions which can be useful for testing.

Thanks in advance,
Mihai Andrei,
Sr. Software Engineer,
IBM Romania

6

Hi,


Thanks for the file, it will help.

I have logged your file to attach with your existing issue in our Issue tracking system.

I have also asked the concerned developer to update on it, once he provide any update or eta, I will let you know here.

Thank you.
7

Hi,


Thanks for using Aspose.Cells.

GCD and CONVERT function work fine with current versions/fixes. For other functions, the precision issue cannot be fixed currently.

Please download and try the following latest fix

Aspose.Cells for .NET v16.12.4 (.NET 2.0) compiled in .NET Framework 2.0.
Aspose.Cells for .NET v16.12.4 (.NET 4.0) compiled in .NET Framework 4.0.