Friday, October 12th 2007

Microsoft Excel 2007 Calculation Issue Fix Available

Two weeks ago, an issue involving the calculation of numbers around 65,535 and 65,536 has been found in Microsoft Excel 2007. If you try to calculate "=850*77.1" in Excel 2007, it will display an incorrect value, but if you then multiply the result by 2, you will get the correct answer. As of today, fixes for this issue in Excel 2007 and Excel Services 2007 are available for download here. Microsoft is in the process of adding this fix to Microsoft Update so that it will get automatically pushed to users running Excel 2007 or Excel Services 2007. Additionally, the fix will also be contained in the first service pack of Office 2007 when it is released. The release date has not yet been finalized.Source: MSDN blog
Add your own comment

7 Comments on Microsoft Excel 2007 Calculation Issue Fix Available

#1
lemonadesoda
Oh my goodness, such a simple math bug in Excel. That is EXTREMELY embarrassing for MS. How can this happen? Don't they use the same math libraries as previous Excel products. Do all Excel versions have the same problem?

The problem could be much bigger than the example shown. Is it just the "display-number" function bug, or is the bug in the variables/maths themselves? If so, ouch!
Posted on Reply
#2
Dr. Spankenstein
Duh! That happens to be tha maximim value of integers for a 16-bit OS!;)
Ever try to see what the default value for the last cell in Excel is? I'll give you two guesses...

I have to chuckle every time I see that one dudes sig that has the faux dictionary entry for Windows:

win-does: A 32-bit extention and graphical interface for a 16-bit patch for an 8-bit OS from a 2 bit company that can't stand one bit of competion.


...or something along those lines, I'm quoting from memory!

Just goes to show how much effort they actually put into futhering their software. Just making the "pig" prettier!

Cheers,

Bryan
Posted on Reply
#3
KennyT772
"win-does: A 32-bit extention and graphical interface for a 16-bit patch for an 8-bit OS from a 2 bit company that can't stand one bit of competion."

win-does: A 32-bit extention and graphical interface based on a 16-bit patch of an 8-bit OS built for a 4-bit microprocessor coded by a 2 bit company that can't stand one bit of competion.

Correct version :toast:
Posted on Reply
#5
theonetruewill
Bah, who cares- they fixed it. We can't expect software to be perfect. I personally love Excel 2007. I hated Excel before I use this version and found it tiresome to use. Now I find it far more intuitive and easy to work with. What can I say, I'm a fan of Office 2007.
Posted on Reply
#6
lemonadesoda
No, I'm serious. We use Excel and VBA for doing all sorts of stuff, incl. financial analysis. I truely hope this is just a "display bug" and not a calc bug.
Posted on Reply
#7
WarEagleAU
Bird of Prey
Im glad they got it fixed. one of the cool things about Office (not sure if openoffice.org or any of the others do this) is the calculator function in the program (word, excel, etc)
Posted on Reply