This is true for all languages using floating point representation. (c, python, javascript) will all return the same result.
No, they will not. Why don’t you try my example in C, and see for yourself? I am well aware of floating point approximations, and carefully wrote “I totally understand that floating point numbers are stored/represented “approximately”. But I have never seen a language give such a non-accurate result with numbers like these” The issue is the JavaScript inaccuracy with such “modest” numbers, rather than in the 10th significant digit of some number.
Just use integer and do your displaying by dividing by 100 at the last minute.
Umm, this is Handsontable, the user enters the numbers/formulas into cells, its (JavaScript) code does the math. I cannot make it do integer stuff instead, and I don’t think users will be too happy if you tell them they should do all their calculations that way …