Brier Dudley's Blog
Brier Dudley offers a critical look at technology and business issues affecting the Northwest.
E-mail Brier|
206.515.5687
|
Follow Brier on Twitter|
Microsoft Pri0 blog|
Subscribe | Blog Home
September 26, 2007 11:48 AM
Excel has a bizarre glitch
Posted by Brier Dudley
Just what Microsoft doesn't need, in the middle of a rumble over Office: an exotic glitch in Excel 2007.
It seems like a joke that only math geeks would get, but it's true.
Excel 2007 fails to correctly multiply numbers "around 65,535," according to an explanation the company posted today. It said a fix is coming shortly, after it's tested to be sure it doesn't cause other problems.
Technically, the software is doing the calculation properly, but it's displaying an incorrect number to users who want to, say, multiply 5.1 by 12,850. From the explainer:
This issue was introduced when we were making changes to the Excel calculation logic in the Office 2007 time frame. Specifically, Excel incorrectly displays the result of a calculation in 12 very specific cases. ... The key here is that the issue is actually not in the calculation itself (the result of the calculation stored in Excel's memory is correct), but only in the result that is shown in the sheet. Said another way, =850*77.1 will display an incorrect value, but if you then multiply the result by 2, you will get the correct answer (i.e. if A1 contains "=850*77.1", and A2 contains "=A1*2", A2 will return the correct answer of 131,070).
The explanation is good, but as far as users are concerned, it doesn't work right.
Excel users are generally so invested in the product, they probably just want it fixed and won't dump the software. But you just know IBM's going to bring this up at every sales call for the next decade.
Posted by Brier
3:09 PM, Sep 26, 2007
You're sure right, Bob.
Definitely a bad week. I wonder if they're getting distracted by the Google obsession or something.
Mar 18, 08 - 12:00 AM
SourceLabs launches open-source support suite, new Linux play
Mar 17, 08 - 12:16 PM
Amazon pre-announces Microsoft's Vista SP1 ship date
Mar 17, 08 - 09:32 AM
A vision of the Web services future Microsoft is developing
Mar 14, 08 - 02:15 PM
MySpace goodies coming to WSJ, CTO says
Mar 13, 08 - 04:43 PM
Nanaimo gaga for Google

general classifieds
Garage & estate salesFurniture & home furnishings
Electronics
just listed
More listings
POST A FREE LISTING

- Reeves Nelson gets the boot --- again | Husky Men's Basketball Blog
- Quake sped up Earth's rotation
- Recipe: Thin Crisp-Style Pizza Crust
- Martyrdoms, border violence, a tree-eating android are all a part of 'What I See'
- Tori Amos communes with classical, other pasts
- Is death knocking at your door? Check odds on the Web
- Cruel fate, two floors divide them | Nicole Brodeur
- Swimming | Bremerton High grad Adrian wins gold
- A lenticular cloud forms over Mt. Rainier during the RAMROD cycling rally | Picture This
- Close-up | Why the poor pay more: More in money, time, hassle, exhaustion, menace
- China’s wealthy paying cash for Eastside luxury homes
- Sex-with-animals advocate told to stay off Internet
- Marine, dog partner reunited in surprise ceremony
- 5 favorite day trips
- Garden lovers: Heronswood open house is May 18 | Ciscoe Morris
- A short train with a lot of heritage | Picture This
- LGBT students get $600,000 in scholarships from 2 groups
- Federal Way girl rewarded for dodging dangerous stranger
- Diversity means opportunity in Tukwila
- The real scandal of Benghazi

March
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
| 1 | ||||||
| 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| 9 | 10 | 11 | 12 | 13 | 14 | 15 |
| 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| 23 | 24 | 25 | 26 | 27 | 28 | 29 |
| 30 | 31 |

Video
Demo of the Week: TeachStreet.com
Share your thoughts!
Gadgets and games | Fun stuff I've written about lately includes Apple's iPhone, Hewlett-Packard's HDX laptop and Microsoft's Halo3. Also on the radar are new digital video boxes such as the Tivo HD and the Vudu.


Posted by Bob
2:32 PM, Sep 26, 2007
You can tell a lot about a company by the job it does on the details. Excel issues. Halo disc packaging issues. Ultimate extras that were promised but don't ship. MSFT just can't seem to get out of its own way.