Free Support Forum - aspose.com

Aspose.Cell For Java ROUNDUP result is incorrect

Hi,

I’m using aspose-cells (v.18.9) for java and faced with strange issue.
I have an Excel contains this formula :

=ROUNDUP(0,00948;5)

When the formula is calculated with aspose, the value “0.00949” is obtained, although it is supposed to be “0.00948” as excel calculates itself.

Aspose.Cells.Cell [ C8; ValueType : IsNumeric; Value : 0.00949; Formula:=ROUNDUP(0.00948,5) ]

Please help…

By the way, ROUNDUP works fine for the following numbers…

=ROUNDUP(0,00947;5) >>>Aspose.Cells.Cell [ C9; ValueType : IsNumeric; Value : 0.00947; Formula:=ROUNDUP(0.00947,5) ]

=ROUNDUP(0,00949;5) >>>Aspose.Cells.Cell [ C10; ValueType : IsNumeric; Value : 0.00949; Formula:=ROUNDUP(0.00949,5) ]

@gkucukeren,

We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSJAVA-42729 - Wrong value calculated by ROUNDUP()

@gkucukeren,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

Thanks a lot. I am looking forward.

@gkucukeren,

You are welcome.

@gkucukeren,

Please try our latest version/fix: Aspose.Cells for Java v18.9.5 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells for Java_v18.9.5.zip (6.3 MB)

It looks fine, thank you for your quick action.

When can we download from your maven repository ?

com.aspose
aspose-cells
18.9.5

@gkucukeren,

This fix will be available via Maven when Aspose.Cells for Java v18.10.0 is released in the last week of October 2018. You will be notified when new version is released.

The issues you have found earlier (filed as CELLSJAVA-42729) have been fixed in Aspose.Cells for Java 18.10. You can also get the latest Aspose.Cells for Java version from Maven repos. with simple configurations. Please see the document for your reference: https://docs.aspose.com/display/cellsjava/Installation

This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi