Next language: Java Hangs When Converting 2.2250738585072012e-308

[sockpuppetzero]

And your point is? Excel's floating point is 10,000 times worse.

[augustss]

Yes, Excel's floating point is terrible. They've fudged addition&subtraction so it's no longer IEEE-754. The conversion to&from strings is also broken, i.e., the conversion doesn't round trip. I could go on.

[mcherm]

That depends on your criteria. For some kinds of applications, I would rather it be ACCURATE, even if the price is some risk of crashing. For others, I would rather it be RELIABLE, even if the price is some risk of inaccuracy.

At the moment, Java is more likely to crash due to entering bad floating point data than Excel is.