[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. about handsontable HOT 6 OPEN

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/

from handsontable.

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.

from handsontable.

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.

from handsontable.

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.

from handsontable.

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.

from handsontable.

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.

from handsontable.