ROUND function cannot round a value greater than 922337.20

Aspose.Cells Product Family
1

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

2
Hi,

I have tested your scenario a bit with latest latest fix: Aspose.Cells for .NET v7.1.0.2 it works fine with it. Here is my sample code:

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");
3

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

4

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.
5

Hi,

We have fixed this issue. Please download: Aspose.Cells for Java v7.1.0.4

6

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.