» deutsch deutsch

Little calculation imprecision of 53%

Update: Im Excel-Team-Blog wurde eine kleine Erklärung veröffentlicht (englisch), es beträfe “nur” die Anzeige, nicht das zwischengespeicherte Ergebnis. Dumm also “nur” für die, die auch mal Werte anzeigen lassen und nicht nur damit rechnen…

Update 2: Ein Hotfix ist mittlerweile verfügbar.

Microsoft Excel 2007, a spreadsheet calculation program for which the correctness of calculations is not quite unimportant, messes up some multiplications that should result in 65,535, e.g.

850 * 77.1 = 100,000

How it gets the idea to turn a result that has the lowest 16 bits (integer representation) all set to 1 into 100,000 (decimal) – and only with some pairs of numbers, not all – I have no idea. Maybe they wanted to hide another bug or flaw this way… anyway, that’s become a complete flop. They want to release a patch as soon as possible…

:hammer:

Maybe it was just a test to see if people are actually using Excel 2007 already and not stick with older versions (which probably many companies do)…?

(via Golem.de)

Update: The Excel Team Blog published a little explanation, according to which “only” the display is affected, not the stored result. So it’s “only” bad for those who have results displayed and don’t just calculate…

Update 2: A hotfix is now available.

Similar posts:

Leave a Reply

All inputs are optional. The e-mail address won't be published nor shared.

  • Moderation: Comments from first-time commentators must be approved manually before they appear.
  • Behave yourself! No insults, no illegal content, etc.! Should go without saying, don't you agree...?
  • Website: I don't mind blogs with ads, but purely commercial links are not welcome and will be deleted. Just like pure spam comments.
  • E-mail notification on new comments: You will have to activate this function once with a link in an automatically sent confirmation mail. These notifications can be disabled again with the link in every mail, of course.
  • Twitter: If you got a Twitter account, you can enter your Twitter name (with or without the @, doesn't matter) which will then be displayed next to any comment (including old ones) that contain the same e-mail address. (Which also means that you must fill in that e-mail field.)
  • Your own image (avatar)? Register at Gravatar.com with your e-mail address and upload an image – this will appear here and on many other blogs (as long as you specify your e-mail address here, of course).
  • Allowed HTML tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <sub> <sup> <big> <small> <u>