Inconsistent results with CalculateFormulas

Aspose.Cells Product Family
1

Hi,

I am experiencing issues with the attached workbook. CalculateFormulas doesn't give the same results as MS Excel.

I am using the latest version of Aspose.Cells for Java. I am simply opening the workbook, calling the calculateFormula API and saving the result.

Can you please look into this issue?

Thanks and regards,

VR

2

Hi,

Thanks for your posting and using Aspose.Cells for Java.

I have attached the output file generated by the latest version. Please check it at your end and let us know your feedback.

Please also elaborate your issues with screenshots highlighting them with red circles.

I used the following code to test your issue.

Java


String filePath = “F:/Shak-Data-RW/Downloads/Aspose_BUG.xlsx”;


Workbook workbook = new Workbook(filePath);

workbook.calculateFormula();

workbook.save(filePath + “.out.xlsx” );

3

Hi,

Thanks for having had a look. Hereafter is what we get:

Result by aspose for the first 6 lines in the yearly tab:

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Date

Rank

30/06/2012

1

438,738,254.56

438,738,254.56

-

-

2.00

30/06/13

2

438,738,254.56

438,738,254.56

-

-

1.00

30/06/14

3

-

-

438,738,254.56

438,738,254.56

0.00

30/06/15

4

-

-

-

-

0.00

30/06/16

5

-

-

-

-

0.00

30/06/17

6

-

-

-

-

0.00

Excel for the first 6 lines in the yearly tab:

Date

Rank

30/06/2012

1

6,345,318,333.97

6,345,318,333.97

-

-

8.91

30/06/13

2

5,895,728,810.44

5,895,728,810.44

449,589,523.53

449,589,523.53

7.91

30/06/14

3

5,456,990,555.88

5,456,990,555.88

438,738,254.56

438,738,254.56

7.52

30/06/15

4

5,019,000,677.07

5,019,000,677.07

437,989,878.81

437,989,878.81

7.12

30/06/16

5

4,608,646,466.32

4,608,646,466.32

410,354,210.74

410,354,210.74

6.74

30/06/17

6

3,912,288,719.86

3,912,288,719.86

696,357,746.46

696,357,746.46

6.34
4

Hi,

Thanks for your clarification.

We have found your mentioned issue using the latest version:
Aspose.Cells
for Java v7.3.3.4

We have logged this issue in our database. We will look into it and fix this issue.

Once the issue is fixed or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSJAVA-40380.

5

Hello,

Do you have any news about this issue?

Regards and best wishes for the new year
VR

6

Hi,

Thanks for your wishes and Happy New Year to you as well from Aspose. :slight_smile:

We are afraid, at the moment, there is no update for you. However, in order to escalate this issue, I have logged your comments.

Please spare us some more time. Hopefully, your issue will be fixed soon.

7

Hi,

Thanks for your posting and using Aspose.Cells for Java.

We have fixed this issue.

Please download and try this fix: Aspose.Cells for Java v7.3.5.2 and let us know your feedback.

8

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

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