Error en multiplicación en Excel 2007

[marcoszorrilla]

Excel 2007 Multiplication Bug
Posted by kdawson on Monday September 24, @10:37PM
from the be-fruitful-and-all-that dept.
Microsoft Math IT
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."

Enlace

Un Saludo.

[[marceloalegre]]

jajaja que verguenza!!!, un bug terrible....
aca paso otro enlace en español del tema....

http://www.kriptopolis.org/excel-200...la-calculadora

[radaalvaro]

Me parece un error terrible..., como es posible que puedan tener un BUG, en algo tan básico... cuando es lo mínimo que se le pide a EXCEL.

Viendo esto, me imagino que deben existir otro grupo de errores de este tipo, de modo que no se puede confiar en ese producto.

Bueno... a buscar otras alternativas... (Opinion personal).

Saludos.

[[Al González]]

Si esta noticia es cierta, me quedo sin palabras.

¿Alguien que tenga Excel 2007 para corroborarlo?

Al González.

[jhonny]

Empezado por Al González

¿Alguien que tenga Excel 2007 para corroborarlo?

Yo tengo Microsoft Excel 97 SR-1 y funciona muy bien . Pero de verdad, me uno a la petición de Al González.

[[egostar]]

Entren a este link y hagan la prueba, yo ya la hice......

Salud OS

Edito: Necesitan IExplorer, obviamente,

[radaalvaro]

Empezado por Al González

Si esta noticia es cierta, me quedo sin palabras.

¿Alguien que tenga Excel 2007 para corroborarlo?

Al González.

Yo tengo Excel 2007 y es cierto... lo probe, y efectivamente muestra la falla.

Ya no hay confianza en ese producto.

Saludos.

[[maeyanes]]

Aquí una explicación del bug de Excel 2007:

Empezado por Joel on Software

Explaining the Excel Bug
This item ran on the Joel on Software homepage on Wednesday, September 26, 2007

By now you've probably seen a lot of the brouhaha over a bug in the newest version of Excel, 2007. Basically, multiplying 77.1*850, which should give you 65,535, was actually displaying 100,000.

Before I try to explain this, I should disclose that I did work on the Excel team, but that was thirteen years ago. I haven't been there for a long time. I don't even think I know anyone on that team any more. I'm just trying to explain the bug a little bit as a public service.

The first thing you have to understand is that Excel keeps numbers, internally, in a binary format, but displays them as strings. For example, when you type 77.1, Excel stores this internally using 64 bits:

0100 0000 0101 0011 0100 0110 0110 0110
0110 0110 0110 0110 0110 0110 0110 0110

The display is showing you four characters: "7", "7", ".", and "1".

Somewhere inside Excel is a function that converts binary numbers to strings for displaying. This is the code that has the bug that causes a few numbers which are extremely close to 65,535 to be formatted incorrectly as 100,000.

....

Enlace


Saludos...