• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

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 said:
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.
Click to expand...
Welp, I only have the 32 bit version of Excel on my desktop so Excel can't access all that bodacious RAM. 🙁
 
IronWing said:
Edit: that's 17,179,869,184 cells.
Click to expand...
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:
b92xj29.jpeg
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top