Friday, October 05, 2007

And in the "Oow, I'm glad I'm not in that department" department.

The latest Woody's Office Watch reports that Excel 2007 can't format 2^16 or 2^16-1 properly, instead deciding to show it as "100,000"

image

Heh. It's not too bad. According to Microsoft, the bug only affects 12 numbers (or is it 2, I'm not sure, but the quote says 12) out of a virtually infinite number space. From Woody's; "They (Microsoft)point out that Excel can use " 9.214*10^18 different floating point numbers " but the bug only affects 12 of that incredibly large number of possibilities".

Oh man. Can I use that one with my next off-by-one mistake? (hey, I don't make 'em much anymore but still...).

posted on Friday, October 05, 2007 4:40:10 PM (Central Standard Time, UTC-06:00)   •  # •  Comments [4] • 
Kick it •  Add to del.icio.us •  View blog reactions;