Software // Enterprise Applications
News
9/26/2007
12:09 PM
50%
50%

Microsoft Says Excel 2007 Produces Math Errors

The company says it is working on a fix for the bug, but has yet to release it.

Red-faced officials at Microsoft have acknowledged that the latest version of the company's Excel spreadsheet program -- an integral part of Office 2007 -- produces significant errors in a small number of cases.

The problem also affects the server-resident version of Excel -- Excel Services.

The officials said Microsoft is working on a fix for the bug, but has yet to release it.

In a blog posting Tuesday, members of Microsoft's Excel development team said the flaw occurs during calculations that would ordinarily result in, or be close to, the number 65,535. Instead, Excel produces a result of 100,000.

The Excel developers said they're not taking the problem lightly. "We take calculation in Excel very seriously and we do everything we can in order to ensure that calculation is correct for all cases," said the blog posting. Microsoft Excel is widely used in everything from basic, back office number crunching to advanced applications such as aeronautics and bridge design.

Excel team members said the glitch is the result of a floating point error -- the same sort of bug that infamously plagued Intel's Pentium chips in 1994. Put simply, a floating point error occurs when a computer -- or a human -- places the decimal point in a string of numbers in the wrong spot. It's an error common to high school math students.

Excel can store millions of floating point numbers. Twelve of those will cause the error, according to the Excel developer blog. The 16-digit numbers cannot be entered directly into Excel because the program will round them off to its maximum, 15-digit display. But the error will occur if the numbers -- six of which are between 65,534 and 65,535 and six of which are between 65,535 and 65,536 -- are the product of a calculation.

"We've come up with a fix for this issue and are in the final phases of a broad test pass," the Excel developers' blog states.

Microsoft said Excel's math isn't wrong, just the way it displays the answers: "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," the blog post states.

While the error may seem minor, it comes at a time when Microsoft's Office franchise is under threat from free and low-cost alternatives offered by well-heeled rivals like Google and IBM. On Wednesday, IBM said its free Lotus Symphony suite -- which includes a spreadsheet -- garnered more than 100,000 downloads during the first week of availability.

Comment  | 
Print  | 
More Insights
Building A Mobile Business Mindset
Building A Mobile Business Mindset
Among 688 respondents, 46% have deployed mobile apps, with an additional 24% planning to in the next year. Soon all apps will look like mobile apps and it's past time for those with no plans to get cracking.
Register for InformationWeek Newsletters
White Papers
Current Issue
InformationWeek Tech Digest, Nov. 10, 2014
Just 30% of respondents to our new survey say their companies are very or extremely effective at identifying critical data and analyzing it to make decisions, down from 42% in 2013. What gives?
Video
Slideshows
Twitter Feed
InformationWeek Radio
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.