Please find attached a test sample.
I am opening this file and calling calculateFormula method.
When the value to be rounded is bigger than 922337.20 (highligted in yellow in the sample file), the result is always 922337.20.
This has been tested on 7.0.3 and 7.1.0.
Please revert on this issue.
Regards
VR
Hi,
Workbook workbook = new Workbook("e:\\test2\\Issue+with+Round+function.xlsx");
workbook.CalculateFormula();
MessageBox.Show(workbook.Worksheets[0].Cells["B4"].StringValue); //OK
MessageBox.Show(workbook.Worksheets[0].Cells["B7"].StringValue); //OK
workbook.Save("e:\\test2\output.xlsx");
Hello,
My request was concerning Aspose.Cells for Java.
The file you are linking only includes the binaries for .NET.
Sorry for the misunderstanding.
Regards
VR
Hi,
Thanks for mentioning it.
This time I can notice the issue. I can find the issue as you mentioned by using the following sample code with your template Excel file.
Sample code:
Workbook workbook = new Workbook(“e:\test2\Issue+with+Round+function.xlsx”);
workbook.calculateFormula();
System.out.println(workbook.getWorksheets().get(0).getCells().get(“B4”).getStringValue()); ///922337.20 - Not OK
System.out.println(workbook.getWorksheets().get(0).getCells().get(“B7”).getStringValue()); ///922337.20 - Not OK
workbook.save(“output.xlsx”);
I have logged a ticket with an id: CELLSJAVA-40124. We will look into it soon.
Thank you.
The issues you have found earlier (filed as CELLSJAVA-40124) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by aspose.notifier.