Category Archives:

Finds

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.

How silent is the Chinese Mafia

Seen earlier on frischgebloggt.de (which lists new posts from many German blogs), about a gunfight among Chinese in Neuss (German):

clipping: Tiraden in Deutschland

Headline translation: “Tirades in Germany?” (to the ENJOY blog (German) – corrected in the mean time)

Of course there are tirades in Germany! Way too many, especially from politicians! :mrgreen: I doubt, however, that the Triads are that verbose. Regardless of how much – or how little – the police knows about them (and, yes, doubting their presence in this country is quite naive).

(Please don’t be mad, Rai – I don’t mean to be evil or insulting at all when I show small writing mistakes or foreign word errors; even large newspapers find themselves e.g. on Zwiebelfisch (German).)