September 27, 2007

Calculation Issue in Excel 2007

Even the big guys don't get it right all of the time. So it is quite difficult to expect it from the small guys. Anyways, here is a new MS issue which is heard to have been solved recently.

What had happened was that in Excel 2007, all calculation using the number 65,535 turned out to be wrong. For example if you did any of these =5.1*12850; =10.2*6425; =20.4*3212.5 the answer came out to be 100000 rather than 65,536. Funny little bug you might say, but imagine the crap you would be under if you found out this you paid extra tax because of some calculation mistake by the software. Real life issues can really be quite difficult to handle.

But it has been heard that the issue is about to be resolved. David Gainer has stated on the Microsoft Excel Blog that they are testing the fix for the same, and the patch would be out real soon.

So the next time you sit down to write your software, make sure you've spent more time testing it, because MS can say that it would be fixed soon, not all of us can always be as lucky.