Incorrect value read after calculation

Using Aspose.Cells 7.7.0 and Java 6.0.


Again, sorry for the generic subject as I am not sure which function is causing the issue.

book.getSettings().setCreateCalcChain(true);
book.getSettings().setCalcMode(CalcModeType.MANUAL);

Worksheet worksheet = book.getWorksheets().get(“energy status”);
String myValue = worksheet.getCells().get(“A1”).getDisplayStringValue();

book.calculateFormula();

Assert.assertEquals(myValue, worksheet.getCells().get(“A1”).getDisplayStringValue());

The test fails because the value, which originally is negative, becomes positive (ignoring the difference in value due to previously reported issue).

Regards,

Steven.

Hi Steven,

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

We were able to observe this issue. The value of cell A1 is read positive while it was negative originally after workbook.calculateFormula(). We have logged this issue in our database for investigation. We will look into it and resolve 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-40700.

Hi,

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

Please download and try this fix: Aspose.Cells for Java v7.7.0.2.

We have fixed the issue that negative value became positive after calculation.

Thanks Shakeel.


I have retested. The issue seems to have been fixed.

Hi Steven,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is resolved with the latest version. If you encounter any other issue, please feel free to post, we will like to help you further.

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


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.