- details how the bug works,
- shows the bug is a rendering bug, not a math error as many reported,
- shows how it was likely introduced by comparison to Excel 2002 and Excel 2000 behavior (the bug seems to have been inserted when updating an older 16-bit formatting routine to a 32-bit equivalent),
- explains how the just released hotfix corrects the behavior, confirming the analysis of the bug,
- and demonstrates why exactly twelve values out of more than 9*10^18 (approx 2^63) possible 64-bit floating-point values suffer from this bug.
Slashdot videos: Now with more Slashdot!
We've improved Slashdot's video section; now you can view our video interviews, product close-ups and site visits with all the usual Slashdot options to comment, share, etc. No more walled garden! It's a work in progress -- we hope you'll check it out (Learn more about the recent updates).