I’m using aspose-cells (v.18.9) for java and faced with strange issue.
I have an Excel contains this formula :
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) ]
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) ]