Jesus's middle name is Hume! Caution: Some NSFW images within!

Page 3964 - Seeking answers? Join the AnandTech community: where nearly half-a-million members share solutions and discuss the latest tech.

IronWing

No Lifer
Jul 20, 2001
67,975
25,012
136
On my printer, it's 40,628,331 pages. I also tried placing a 1 in every cell. 8GB of RAM is not sufficient to complete the task. I'll try it on the desktop when I get home.

Edit: that's 17,179,869,184 cells.
Welp, I only have the 32 bit version of Excel on my desktop so Excel can't access all that bodacious RAM. :(
 
Jul 27, 2020
13,170
7,820
106
Edit: that's 17,179,869,184 cells.
Librecalc consumes about 258MB without anything in any cell.

With just one letter in all cells in column A, it consumes 459MB. Per cell, it comes out to 0.196KB.

For all cells, it's about 3216GB. So yeah, not gonna have a machine in my lifetime that can handle a fully populated humble spreadsheet :)

And yes, Librecalc crashed on my 64GB laptop too.

With just a single digit number, it consumes about 0.08789KB per cell.

That's 1440GB required for all cells.

OK, so that's possible on a high end server.
 
Last edited:

mikeymikec

Lifer
May 19, 2011
16,888
7,814
136
b92xj29.jpeg