Vicious Mean Evil MS Excel 2007 Bug

Ah, the perils of floating poing calculation.

Apparently there is a bug in Excel 2007 which causes 12 floating point values around 65535 and 65536 to be displayed incorrectly. Calculations aren’t effected, but the displayed number comes out as 100,000 or 100,001.

I’m guessing this wasn’t an easter egg, or it would be funnier.

Comments

One response to “Vicious Mean Evil MS Excel 2007 Bug”

  1. Ken Avatar

    Let me start by apologizing for the “comment spam”, but I’m trying to contact multiple friends (including you) and I don’t have your most recent email address.

    As you might have realized, my “old” webserver (http://www.innospyre.com) died a hard death. The datacenter it was housed in (Sterling, VA) had issues a few months ago. Last Friday, the server died a hard death without any recent or complete backups. I was pissed, since I lost over 300MB of pictures, blogs, and data. Nearly 3 years of hard work is gone!

    I’ve since switched webhosting companies. I now have the premium plan with Bluehost, providing me Linux/Apache/Tomcat/SSH/MySQL/PostgreSQL/SMTP/FTP/HTTP/300GB HD/3Gbps in a 2-year contract. I’ve already written a cron job to back it up weekly to my SunBlade at home, which I will in-turn backup to DVD.

    Here’s my new webserver and contact information:
    Lathe of Dreams (http://www.latheofdreams.com)
    ken.foreman@latheofdreams.com

    Again, sorry for “comment spam”. I’ll add you to my website under “Friends Link” this week. If you could please update your bookmarks and website links to my site, I’d appreciate it.

    – Ken

Leave a Reply

Your email address will not be published. Required fields are marked *