September 25, 2007

LOL MICROSOFT Serious bug found in Excel 2007. Try multiplying 850 by 77.1 - the answer should be 65535. Do it in Excel 2007 and it's 100000. D'OH! Holy Crap! & LULZ to follow.

posted by Hank Mabuse 17 years ago

Maybe it's an automatic adjustment for inflation.
posted 17 years ago by The Underpants Monster
A bug in a MS product?? HOLY HELL!@100000 TUM pulls it off, yet again!
posted 17 years ago by sugarmilktea
Math is hard.
posted 17 years ago by middleclasstool
s
posted 17 years ago by kitfisto
65535 = FFFF in hex and 1111111111111111 in binary. Looks like somebody forgot to carry the 1.
posted 17 years ago by EdArzakh
s
posted 17 years ago by middleclasstool
S
posted 17 years ago by mothninja
S
posted 17 years ago by middleclasstool
65536 (2^16) is the previous limit on the number of rows you can have in an Excel spreadsheet. 65535 is the top of the 16-bit range, starting from 0.
posted 17 years ago by roryk
Is it still not the limit? I think we're running 2007 at work and it has the same limitation. Could be mistaken about the version, though.
posted 17 years ago by middleclasstool
I thought it had gone up to ONE MILLION ROWS! (evil chuckle, puts pinky into side of mouth). But I'm using 2003, so I've nothing to back that up.
posted 17 years ago by roryk
Somebody needs some time with the flash cards.
posted 17 years ago by BlueHorse
*link to quonsar's article on teh blue about Vista-to-XP downgrade*
posted 17 years ago by petebest
All of this is perfectly fixable by dividing the answer by 1.525902. Hardly a bug at all.
posted 17 years ago by planetthoughtful
I stand corrected. We're on 2003 here.
posted 17 years ago by middleclasstool
petebest wrote: "*link to quonsar's article on teh blue about Vista-to-XP ~~downgrade~~ upgrade*" Fixed that for ya
posted 17 years ago by caution live frogs

Monkeyfilter

of no fixed subtitle

September 25, 2007