Friday, September 28, 2007

Excel 2007 math calculation bug

Microsoft Office Excel 2007 contains a serious bug in its calculation. Try multiplying 850 and 77.1 and Excel 2007 produces 100000 instead of 65535.

OpenOffice.org and Microsoft Office Excel 2003 seems to produce the correct result.

You'll never know if there are other calculation bugs in it; imagine having the wrong numbers of your profit and loss sheet in excel. ^_^

No comments: