Errada al multiplicar a Excel 2007

Llegeixo a Slashdot el següent: Excel 2007 Multiplication Bug:

tibbar66 writes with news of a serious multiplication bug in Excel 2007, which has been reported to the company. The example first that came to light is =850*77.1 — which gives a result of 100,000 instead of the correct 65,535. It seems that any formula that should evaluate to 65,535 will act strangely. One poster in the forum noted these behaviors: “Suppose the formula is in A1. =A1+1 returns 100,001, which appears to show the formula is in fact 100,000… =A1*2 returns 131,070, as if A1 had 65,535 (which it should have been). =A1*1 keeps it at 100,000. =A1-1 returns 65,534. =A1/1 is still 100,000. =A1/2 returns 32767.5.”

Més a http://groups.google.com/group/microsoft.public.excel/browse_thread/thread/2bcad1a1a4861879/2f8806d5400dfe22?hl=en#2f8806d5400dfe22.

L’errada, pels que us fa pal l’anglés, és:

Multiplicar 850*77,1, que hauria de donar 65535, resulta: 100000 !!!!!

La pregunta que em faig veient com van les coses a la UdL és la de sempre, que passaria si aquesta errada la tingués l’OpenOffice. Recordo com algú em va dir que Linux era insegur perqué hi havia un virus per Linux (aquell *experiment* de virus que mai va arribar a estar “on the wild”), mentre que Windows era més segur (sic!).

Deixa un comentari

L'adreça electrònica no es publicarà. Els camps necessaris estan marcats amb *