Developping for the translation industry RSS 2.0

 Tuesday, October 02, 2007

If you haven’t already heard about it, (very unlikely since it has been all over the news) there is a bug in Microsoft’s Excel 2007 that display the wrong result when doing a multiplication.  The bug first shown up with the multiplication of 77.1 * 850 but the Excel team blog tells us that there are 12 specific calculations that are subject to this flaw.

Basically, this is a problem with the internal representation of numbers in Excel that gets translated for displaying.  It’s a conversion bug in the UI part so it won’t affect any calculation, charting or other number analysis on those numbers.  VBA script and COM Interop are also immune to this bug because they use the internal representation and not the number actually rendered on the Excel interface.  Joel of has a really good article that explains the specifics of this bug. 

Every forum and blog posts that I've seen out there, with the exception of Joel’s one, shouts that this is a major/critical bug and start bashing on Microsoft for their “gross incompetence”.  My humble opinion on this is that those guys are going totally overboard and see critical problems when there are, in fact, none.  Since the bug we’re talking about affect only the number displaying but not the internal representation it will affect people’s life only if they do those exact calculations and don’t use the calculation result to do anything else.  The chances of that happening out there exists, I agree.  However, they are so slim that this bug should not be considered critical at all.  Microsoft will probably release a hotfix in the next days/weeks and it will all be history soon.

UPDATE: The Excel team has released a hotfix to correct this issue.  The fix can be found here.

Tuesday, October 02, 2007 2:45:18 PM (Eastern Standard Time, UTC-05:00)  #    Comments [0] -
Comments are closed.

About the author/Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2019
Stanislas Biron
Sign In
Total Posts: 135
This Year: 0
This Month: 0
This Week: 0
Comments: 1
All Content © 2019, Stanislas Biron