PDA

View Full Version : Interesting (or not) fact



SXRguyinMA
09-28-2010, 05:02 PM
Space # XFD1048576 is the last possible space in a spreadsheet on Excel 2007 :D

Yea, work was slow today.....

slaveofconvention
09-28-2010, 05:22 PM
almost certainly no coincedence but.... 1048576 is also the number of bytes in a megabyte (1024x1024). 16384 is also 16x1024... (Column XFD is the 16384th by the way lol)

artoodeeto
09-28-2010, 06:27 PM
Interesting. On my copy of Excel 2003, the last possible space is IV65536. Yep. I'm bored too....

slaveofconvention
09-28-2010, 07:07 PM
256th letter and 64x1024 heh - not really surprising that they'd be "computer numbers"

Excel 2010 goes down to XFD1048576 too - I guess MS decided 17,179,869,184 was enough cells :p

The jump from 16,777,216 in 2003 to 17,179,869,184 was also a x1024... just think, if they'd done it again, we'd be looking at 17,592,186,044,416 and thats a LOT of cells to try to fill heh

SXRguyinMA
09-28-2010, 07:17 PM
almost certainly no coincedence but.... 1048576 is also the number of bytes in a megabyte (1024x1024). 16384 is also 16x1024... (Column XFD is the 16384th by the way lol)

hmmm oddly interesting :D

crenn
09-28-2010, 07:19 PM
Sad thing... it must be that size because someone ran out of space in an older version :P

slaveofconvention
09-28-2010, 07:26 PM
The jump from 16,777,216 cells in 2003 to 17,179,869,184 in 2007 was also a x1024... just think, if they'd done it again, we'd be looking at 17,592,186,044,416 and thats a LOT of cells to try to fill heh

x88x
09-28-2010, 07:37 PM
AMJ1048576 in OpenOffice 3.2 ;)

That's 1024 by 1024^2 for 1,073,741,824 cells.

SXRguyinMA
09-28-2010, 07:38 PM
this is all kinda interesting really lol