Cells Calculations Is Incorrect

Aspose.Cells Product Family
1

There seems to be an issue with calculations involving truncation and multiplying by 1.

We are using version 7.1.0.0, in the following scenario we have encountered a sever problem with the calculation being done by Aspose. We have discovered this issue the day we are suppose to deploy to our production environment. Is this a known issue if so what is the work around. If not than can you provide a fix ASAP.

Scenario setup:

Cell AD9 = 612.81085

Cell Y9 = 1

AE9 formula: =TRUNC(AD9*Y9,5)

Calculated results from Aspose: 612.81084

Expected results: 612.81085
2

Hi,

Thanks for your reporting and using Aspose.Cells for .NET.

We have logged your issue in our database. We will look into it and fix the problems.

Once, the fix is available or we have some other update relating to it, we will let you know asap.

This issue has been logged as CELLSNET-40536.

3

Hi,

We. have fixed this issue. Please download: Aspose.Cells for .NET v7.1.2.5

4

It appears that the 7.1.2.5 fix breaks other scenarios. The fix corrected the original issue, but it has caused other scenarios with the same calculations to be incorrect. When compared to excel, the individual calculations in the chain look correct, but the total value is incorrect. In the 7.1.0.0 version the total comes out correctly. There are inconsistencies in the way Aspose is calculating or evaluating cell values.

5

After furhur trial and error it appears that the fix that was made for the muliply operation with a Trunc function issue needs to be made to all the other operators and or functions like Sum. We had to modify the calculation in the total column to multiply each cell participating in the Sum function by 1 within the Trunc function for the calculation to be correct, we also had to multiply the percision parameter by 1.

6

Hi,

Please provide us your sample project replicating the scenarios where the fix breaks.

We will look into them and fix those issues.

7

The issues you have found earlier (filed as CELLSNET-40536) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.