Wednesday, October 24, 2007

65,535 is a difficult number for Excel 2007

A weird bug has been discovered in Excel 2007, involving calculation of numbers around 65,535. In some specific cases, Excel 2007 displays 100,000, when it should say 65,535. Microsoft claims it's a display error, i.e. that calculated value that Excel uses is supposedly correct, but that seems a bit odd.
Look for all details on the Microsoft Excel team blog.

UPDATE 26 October 2007: meanwhile, Microsoft has issued a fix for this.
Also, if you're interested in a full, in-depth explanation about the issue, have a look at Chris Lomont's detailed report (PDF).

No comments: