By gst
via scienceblogs.com
Published: Oct 02 2007 / 17:37
I've been getting a lot of requests from people to talk about the recent Excel bug. For those of you who haven't heard about this, in Excel 2007, floating point calculations that should result in a number very, very close to either 65,535 or 65,536 are displaying their result as 100,000. It's only in the display though - the underlying number is actually represented correctly, so if you subtract 2 from 65,536, you'll get the correct answer of 65,534 - not 99,998.
Comments
0x0badf00d.livejournal.com replied ago:
Here is even patch for artifical Excel modification:
http://reverse-engineer.info/
Voters For This Link (10)
Voters Against This Link (0)