Value changes after calculation

Aspose.Cells Product Family
1

Hi Aspose.


Using Aspose.Cells 7.7.0.2 and Java 6.

Sorry for the vague subject.

Sample code.

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

Worksheet worksheet = book.getWorksheets().get(“w”);
String cellnum = “A3”;
String myValue = worksheet.getCells().get(cellnum).getDisplayStringValue();
LOG.debug(myValue);
book.calculateFormula();

LOG.debug(worksheet.getCells().get(cellnum).getDisplayStringValue());
Assert.assertEquals(myValue, worksheet.getCells().get(cellnum).getDisplayStringValue());

The value in w!A3 is TRUE, after calculation Cells sees it as FALSE.

The test passes with an xls format but fails for the xlsb (xlsx) format. I have zipped the xlsb as I the upload does not allow this extension.

Regards,

Steven.

ps. Other username is eval.lee. Reseller created this user when we purchased the licensed.
2

Hi Steven,

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

We were able to observe this issue with your source xlsb file using your given code. We have tested it with the latest version: Aspose.Cells
for Java v7.7.0.3 but the problem still occurs. 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 CELLSJAVA-40704.

3

Hi,

Thanks for using Aspose.Cells for Java.

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

4

Thanks Shakeel.


The bug has been fixed.
5

Hi Steven,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is fixed with the latest version. If you encounter any other issue, please feel free to post on our forums, we will be glad to help you further.

6

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

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