Is Microsoft going to fix the bug in Excel 2007 which returns 100000 as the product of 850 and 77.1?
Is Microsoft going to fix the bug in Excel 2007 which returns 100000 as the product of 850 and 77.1?
Last edited by dominicb; 10-11-2007 at 06:39 AM.
Good morning Andrew Turek
No word from Microsoft (yet) on the issue but my guess is they'll have a fix for it very soon. This will be soooooooooo embarassing for them, even a bigger clanger to drop than Intel did with their faulty chip a couple of years back ...
DominicB
Edit : For those not in the know :
http://groups.google.com/group/micro...8806d5400dfe22
Last edited by dominicb; 09-26-2007 at 03:57 AM.
Please familiarise yourself with the rules before posting. You can find them here.
I had forgotten that incident.
"How many Intel engineers does it take to change a light bulb?
1.99999999999 to a sufficiently good approximation!"
Hi Andrew Turek
Like that one"How many Intel engineers does it take to change a light bulb?![]()
![]()
![]()
DominicB
To complement the blog entries above ... Office 2007 users should patch their systems just in case they may encounter the rare conditions that might trigger this calculation error. Fortunately, the calculation results are correct, but they will be displayed incorrectly in the cell itself. The Hotfix is large at 34MB in size
Excel 2007 - Hotfix released to correct calculation bug
http://support.microsoft.com/default.aspx/kb/943075/
Excel 2007 Services - Server based release for Sharepoint environment
http://support.microsoft.com/default.aspx/kb/943076/
This hotfix package fixes the following issue that was not previously documented in a Microsoft Knowledge Base article:
When you perform a calculation in Excel 2007, the following behavior occurs:
• The result of the calculation is a number from 65534.99999999995 to 65535. The calculation is performed correctly. However, the result is incorrectly shown as 100000.
• The result of the calculation is a number from 65535.99999999995 to 65536. The calculation is performed correctly. However, the result is incorrectly shown as 100001
Good news and it worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks