search

handsontable / hyperformula

HyperFormula is an open-source headless spreadsheet for business web apps. It comes with over 400 formulas, CRUD operations, undo-redo, clipboard support, and sorting.
https://hyperformula.handsontable.com/
GNU General Public License v3.0
1.88k stars 107 forks source link

[Bug]: =1.0667-1.0666 count wrong 0.000099999999999989 #1417

Closed wanquantong closed 2 weeks ago

wanquantong commented 2 weeks ago

Description

=1.0667-1.0666 count wrong 0.000099999999999989 correct is 0.0001

Video or screenshots

No response

Demo

https://stackblitz.com/run?file=index.js

HyperFormula version

2.7.0

Your framework

No response

Your environment

chrome 122

thilgen commented 2 weeks ago

This is a limitation of JS - See same results in Chrome console and Node console

Screenshot 2024-06-22 at 2 43 19 PM Screenshot 2024-06-22 at 2 45 03 PM
thilgen commented 2 weeks ago

...and when I raised the same concern 😄

https://github.com/handsontable/hyperformula/issues/1234

adrianszymanski89 commented 2 weeks ago

Hi @wanquantong

@thilgen is right. This is the same case he already reported and was discussed in the mentioned issue. I will close this ticket.