Microsoft Excel 2007 math bug and how to fix it

Subscribe to the Technacular RSS feed  RSS Feed or by Email and receive free daily updates

On September 25th, 2007, David Gainer of the Microsoft Excel group did a post acknowledging a Microsoft Excel 2007 math bug involving calculations of numbers around 65,535 and 65,536.

An example bug is: 77.1 * 850 for which Excel returned 100,000 instead of 65,535.

According to David, the issue was due to change in the Excel calculation logic in Office 2007. The bug affects Excel 2007 and Excel Services 2007.

The patch has been posted here.

Popularity: 7% [?]

Subscribe to the Technacular RSS feed  RSS Feed or by Email and receive free daily updates

Related Posts

  • Excel 2007 : How To Save Excel Chart As Image
  • This post demonstrates an easy way to sa...
  • How To Copy Cells From Excel Which Meet Search Criteria
  • You have a huge excel file and you want ...
  • A hoax: Microsoft Firefox 2007
  • It came as a surprise to me when I saw a...
  • Programmatically Change The Data Range For A Chart In Excel
  • Sometime back I had to figure out ...

    Write a comment:

    Technology Blogs - Blog Top Sites Blogarama - The Blog Directory Technology blogs Technology blogs blog search directory