[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.

handsontable / handsontable

JavaScript data grid with a spreadsheet look & feel. Works with React, Angular, and Vue. Supported by the Handsontable team ⚡

https://handsontable.com

Other

19.15k stars 2.94k forks source link

[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. #10935

Open yanyinqing opened 3 weeks ago

yanyinqing commented 3 weeks ago

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

Your environment

macos,edge

adrianszymanski89 commented 3 weeks ago

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 commented 2 weeks ago

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 commented 2 weeks ago

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.