The Register® — Biting the hand that feeds IT

Feeds

Future of computing safe, thanks to Excel patch

Bug gave wrong results when calculating frequently occuring number

Customer Success Testimonial: Recovery is Everything

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. ®

Regcast training : Hyper-V 3.0, VM high availability and disaster recovery

Latest Comments

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

0
0

@Steven

Not all subsequent calculations work properly. Generally a multiply will use the correct version, but an add will use the wrong version.

0
0

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.

0
0

More from The Register

SCO vs. IBM battle resumes over ownership of Unix
Zombie lawsuit back and wants to suck the brains out of Linux
Bjarne Again: Hallelujah for C++
Plus: Now officially OK to admit you never used STL algorithms
Interwebs taunt Sir Jony over Apple eye candy makeover
Hey Ive, Ive... add more unicorns, willya?
Apple: iOS7 dayglo Barbie makeover is UNFINISHED - report
Plus: You don't like the icons? Blame marketing
Red Hat to ditch MySQL for MariaDB in RHEL 7
So long, Oracle! Don't let the door hit you on the way out
Shy? Socially inadequate? Fiddling with your phone could help
App 'tells the brutal truth' about social inadequates' chatup lines
Java EE 7 melds HTML5 with enterprise apps
New release arrives with GlassFish, NetBeans support
 breaking news
'Office Facebook' firm Tibbr wants you to PAY for mobe-meetings app
Great idea. Punters won't cough for it though
 breaking news
The only Waze is Google: Ad giant tipped to gobble map app 'for $1.3bn'
Pac-Man-satnav-ish upstart in bidding war with Apple, Facebook
 breaking news
PM Cameron calls for modern, programmable computers! (We think)
IT education musings to G8 chiefs to mystify IT industry