Recently there was an issue with Microsoft Office Excel 2007 when performing multiplication calculation. The multiplication formula will show the wrong value when the resultant’s range fall around 65535 and 65536.
The new patch has just been released officially by Microsoft to resolve the issue. However, the effect may not be visible since most of the users are not really aware of such bugs when using Excel worksheet in daily work.
Not much information was disclosed on the actual root cause; but it is suspected to be due to formatting and floating point calculation bug around 65535 and 65536. You can try to experiment yourself by multiplying 850*77.1 using excel worksheet, and you won’t get the correct value of 65535 but instead, it will yield 100000.
RSS
