Excel 2007 calc bug paper

Chris Lomont has recently released an excellent in-depth paper analysing the cause of the Excel 2007 calc/presentation bug. It makes a refreshing change from all those wondering if the problem is to do with the number of rows changing over on the Excel team blog.

His work is based on debugging and disassembling Excel.exe and shows the assembler code around the error. And he’s also checked the effect of the MS patch. Here is the page with a link to the paper. He also compares to the equivalent code in Excel 2002, and notes significant changes between versions.

Its reassuring that after some proper analysis he also reckons the bug is not that big an issue.

With the Excel team not anticipating providing any more info about the error this is the best we’ll get. Lucky then that its very clear and thorough. As these routines were probably written in assembly anyway, there was never going to be any C equivalent made available.

Cheers

Simon

Advertisements

4 Responses to “Excel 2007 calc bug paper”

  1. Ross Says:

    >>His work is based on debugging and disassembling Excel.exe

    I bet MS will be over the moon with that! Fair play to the bloke though theres some hardcore stuff on his web site! (hardcore maths that is before anyone gets excited)

  2. Sam Says:

    Read it today morning and said that it was the most comprehensive and well written article on the subject…I dont think any one in MS could have done a better job…

    Sam

  3. Dennis Wallentin Says:

    Thanks Simon for the heads up on this excellent write up article (although it took some time for me to “read it right”).

    Kind regards,
    Dennis

  4. Methods In Excel » Insight in to the innards of Excel? Says:

    […] Simon (am I obsessed with him?) found this paper about the Excel 2007 bug. It’s not only an excellent investigation in to that bug but is generally very interesting to read, and highlight some of the complexities behind the working of our favour Spreadsheet, well worth a read if you have a fee minutes. Also check out the guys web site form some awesome programming examples. […]

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: