Calculate ROUND Excel function/formula via Aspose.Cells in .NET

Aspose.Cells Product Family
21

Hi Jan Kok,


It works the same as MS Excel calculates. I used your code with your template file and saved the file(attached). I opened the generated file into MS Excel 2007 and re-calculate the formulas the “K32” cell of “rekenblad” worksheet has 0.410 value which is same as Aspose.Cells calculates.

Thank you.
22

Hello Amjad Sahi,

Which version are you using? It works with version 6.0.0.0, but not with version 6.0.0.2 (see post 312713) which resolves a rounding issues from post 312149

Kind regards,

Jan Kok

23

Hi,

Please also test your issue with the current latest version and let us know your feedback. If some functionality is broken, we will fix it asap.

Download:
Aspose.Cells
for .NET v6.0.0.4

24

Hi,

I tested it with version 6.0.0.4. Same result as version 6.0.0.2.

Version 6.0.0.0 does work in this situation the same as Excel.

Kind regards,

Jan Kok

25

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.
26

Hi Shakeel,

Do you have any idea what causes the rounding differences yet?

Kind regards,

Jan Kok

27

Hi,

I have forwarded your question to team and we will update you asap.

Will you please try the latest version though to see if it works fine now? Please download:
Aspose.Cells
for .NET v6.0.1.6

28

Hi,

Did you find any problem?

If yes, please send your sample project to us, we will check it soon.