If you are following the Excel 2007 Bug issue, you might think it was fixed. I say think again.
It you were to start a fresh worksheet and do the simple equation of 77.1 * 850, yes now you do get 65535, not the dreaded 100000 as before installing the patch. Now for proof the bug wasnt fully removed.
Enter the following into an excel 2007 workbook.
a1 =77.1
a2 =850
a3 =a2*a1 (65535)
b3 =dec2hex(a3) (fffe)
a4 =sqrt(a1*a2)^2 (65535)
b4 =dec2hex(a4) (ffff)
a5 =65535 (65535)
b5 =dec2hex(a5) (ffff)
a6 =if(a5=a3,”equal”,”not” (equal)
b6 =if(b5=b3,”equal”,”not”) (not)
It looks like there is still a display problem, displayed numbers are not the values memory has.
What do you think?
