[Bug]: The bug about the ROUND function in the formula, why 21.9/0.2, keeping 0 decimal places, will get 109? In theory, the ROUND function should be rounded to 110.

[yanyinqing]

Describe the bug

The bug about the ROUND function in the formula, why 21.9/0.2, keeping 0 decimal places, will get 109? In theory, the ROUND function should be rounded to 110.

Video/Screenshots

Provide a link to the demo with the bug reproduction

No response

Handsontable version

14.3.0

Framework version

vue2

Your environment

macos,edge

[adrianszymanski89]

Hi @yanyinqing

Thank you for reporting this. I'll consult it with our developer and get back to you once I have feedback on this.

Example: https://jsfiddle.net/handsoncode/dub19jL6/

[yanyinqing]

Hi @yanyinqing

Thank you for reporting this. I'll consult it with our developer and get back to you once I have feedback on this.

Example: https://jsfiddle.net/handsoncode/dub19jL6/

Hello, how is it going so far? Is there any solution or when to update the new version to solve this problem, because this potential problem seriously affects the accuracy of the data.

[AMBudnik]

Hi @yanyinqing - my colleague is off for the week (we have some national holidays coming soon). I see that the subject was mentioned in the dev meeting, but there are no details. I think that we should get some updates here next week.

[yanyinqing]

Hello, how is it going so far? Is there any solution or when to update the new version to solve this problem, because this potential problem seriously affects the accuracy of the data.

Hello, how is it going so far? Is there any solution or when to update the new version to solve this problem, because this potential problem seriously affects the accuracy of the data.

[yanyinqing]

Hi @yanyinqing

Thank you for reporting this. I'll consult it with our developer and get back to you once I have feedback on this.

Example: https://jsfiddle.net/handsoncode/dub19jL6/

Hello, how is it going so far? Is there any solution or when to update the new version to solve this problem, because this potential problem seriously affects the accuracy of the data.

[adrianszymanski89]

Hi @yanyinqing

I'm sorry for the late response. We determined that the precisionRounding limitation causes this issue, and while setting it to, for example, 15 should solve the hardcoded limit is actually 14. I will make sure to update you once this issue is added to the roadmap and fixed.