Formula in template rounds up to two digits

[profiler007]

Hello,

Question from out client:

Formula in template rounds up to two digits after the decimal point.

They have two merge fields like the following:

«Contact_Decimal1» = 333.12345
«Contact_Decimal2» 50000.12345

And two that are configured to show the result of division and accumulation with 5 digits after the decimal (333.33/50000=0.0066666). However, once calculated the returned result is rounded off at the second digit after the decimal:

Result: result is rounded off at the second digit after the decimal (e.g. $ 0.01000)
Expected: result is rounded off at the 5th digit after the decimal (e.g. $ 0.00666)

Individual fields are displayed correctly with 5 digits after the decimal, but the result of division or accumulation is always rounded to two digits after the decimal point.

The templates is attached.

Regards

[rachel.lei]

Hello,

Thanks for your inquiry.

I have reproduced your issue and logged it in our bug tracking system with the ticket SPIREDOC-6505 for further investigation and fixing. If there is any update, we will let you know.

Apologize for the inconvenience caused.

Sincerely,
Rachel
E-iceblue support team

[rachel.lei]

Hello,

Thanks for your patience.

Glad to inform you that the issue of ticket SPIREDOC-6505 has been resolved in the newly released Spire.Office Platinum(Hotfix) Version:6.9.1. Welcome to download the new version from the following links for testing.

Website link: https://www.e-iceblue.com/Download/down ... t-now.html
NuGet link: https://www.nuget.org/packages/Spire.Office/6.9.1

Sincerely,
Rachel
E-iceblue support team

[profiler007]

Great, thanks!

[rachel.lei]

You are welcome.

If you encounter any problems during the testing, just feel free to contact us.

Sincerely,
Rachel
E-iceblue support team