Another new bug for all Anti-Microsoft groups to pound on. Excel 2007 shows 65535 as 100000
Microsoft’s Bug Description: 6 floating-point numbers between 65534.99999999995 and 65535, and 6 between 65535.99999999995 and 65536 have problems. The problem is only skin deep. It is an issue with the function that displays the number. In fact, the number is stored correctly in memory. MSDN Blog
But customers who checked the same are doubtful that it’s only skin deep. Few show examples that the cause could be more than the function that converts binary to displays the cell value.
I’ve always loved the creativity of the AMGs: One Example :- )
And I also hate when MS is cursed for the sake of nothing
“Tomorrow if i lose money because my bank uses Excel 2007, Will MS repay me?”
“Tomorrow if you gain money because your bank uses Excel 2007, will you share your profit with MS?” OMG, Who’s gonna stop this heck?
Now, What really caused the problem? We’ll get to know when MS is up with a fix.:-) Though there are interesting articles proclaiming the cause as multipliers divisible by 17 and floating point precision issues with the result.
But why should testing miss this? Test scripts for Excel are in VBA. Because the problem is in the display of the number and not in the value stored in memory(MS says), VBA would have fetched the correct value from the cell.
“There are two ways to write error-free programs; only the third one works.” – Alan J. Perlis
