The Inquirer-Home
Comments
Actually...

@Raj:
Actually, in Excel 2007, rows end at 1,048,576.

posted by : Evan, 05 November 2007 Complain about this comment
2 to the 16th overflow?

This is a freshman year programming mistake. Is quality control so lacking at Microsoft these days that they don't even test for overflows?

posted by : raboof, 02 October 2007 Complain about this comment
That's because

The article is talking about Excel 2007 you numpty.

posted by : Olaf, 26 September 2007 Complain about this comment
Confirm

Wao, this will be the best bug, hopefully they can fix it in SP1. I have try multiply 850 by 77.1 in Excel 2007 + Autopathcer Office 2007 August 2007 and still got the 100.000.

posted by : Hok, 26 September 2007 Complain about this comment
Read again...

If you read the article carefully, they are talking about Excel 2007

posted by : Catalin, 26 September 2007 Complain about this comment
Excel Limit ?

Excel rows end on the very next number 65536 - wonder if thats got something to do with it

posted by : Raj, 26 September 2007 Complain about this comment
Interesting

It seems Excel 2007 also can't calculate 840*78.0178571428571428571428571428571 but correctly reports 65535 for 840*78.017857142857142857142857142857 (dropping the last decimal). Evidently the bug is smart enough to affect only calculations that produce "exactly" 65535.

posted by : Jonathan, 26 September 2007 Complain about this comment
Is it a display thing

when you calculate 850 * 77.1 and then from the result subtract 2 you get what looks like...
1000000 - 2 = 65533...

posted by : Teach, 26 September 2007 Complain about this comment
16 bit binary

"65535 is a frequently occurring number in the field of computing because it is the highest number which can be represented by an unsigned 16 bit binary number."

http://en.wikipedia.org/wiki/65535_(number)

posted by : joebloggsy, 26 September 2007 Complain about this comment
It does work

And if you multiply 77.1*850 you get 5052748.5. Put 850 in on cell (A) and 77.1 in another (B). Try A*B and B*A.

posted by : Dede, 26 September 2007 Complain about this comment
Hmmm...Mine Works...

My Excel 2003 has 850*77.1 equaling 65,535. Might already be patched?!?!

posted by : Tweak, 25 September 2007 Complain about this comment

Excel goes nuts at 65,535

aboutus
Advertisement
Subscribe to INQ newsletters
Advertisement
INQ Poll

Authorities in several countries raided Megaupload recently, shut down all of its services, seized hundreds of servers and arrested several of its executives on criminal charges.

Do you think the move was justified?