3 min read

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.