Future of computing safe, thanks to Excel patch
Bug gave wrong results when calculating frequently occuring number
Microsoft has released a fix for a curious flaw that threatened to confound engineers who use the latest version of Excel.
The patch fixes a bug that caused Excel 2007 and Excel Services 2007 to spit out incorrect results when calculating numbers around 65,535 and 65,536. The former number is the highest that can be represented by an unsigned 16-bit binary number, so the bug had the potential to lead hardware and software engineers seriously astray.
In due course, Microsoft Update will automatically push the update to all users of Excel 2007 and Excel Services 2007. The patch will also be included in the first service pack of Office 2007, whenever it becomes available.
Microsoft's David Gainer, who announced the patch here, didn't explain how the bug came to be. (One commenter wondered aloud if it was the result of over-optimized floating-point formatting.) However, he thanked users for their patience. ®
Accountants use Excel!?
"I'd bet good money that accountants and engineers (if there are any that actually use Excel)"
Do accountants use excel? Is the pope chatholic?
Excel has some useful features for the bean counters out there, shame it can't add properly
Not all subsequent calculations work properly. Generally a multiply will use the correct version, but an add will use the wrong version.
oh come on...
Any Eng'r worth their salt will not use Excel except to double-check a hand calc.
It's ok. Bridges will not fall nor will planes drop from the sky due to an excel fault.