Ask Your Question
0

How much is too much DATA in 1 document

asked 2016-09-23 19:56:55 +0200

JG101 gravatar image

CALC

I currently have 60 sheets in one document full of data: 1000 rows each. column A - column ZZ

How much info / data can a document hold before it will shut down or no longer open.

edit retag flag offensive close merge delete

Comments

This tragedy can happen at any moment. File size is not the only reason for the crash. How much space your file occupies on disk? How many formulas in the workbook? How many different types of cell design and text?..

JohnSUN gravatar imageJohnSUN ( 2016-09-23 20:01:51 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2016-09-23 22:16:49 +0200

erAck gravatar image

With a 64-bit build it's more or less a question of RAM and available free memory. An empty sheet takes ~250KB, an ordinary cell with numeric content takes ~10-20 bytes, a cell with text the text length plus ~10-15 bytes, a cell containing a formula expression easily 100 bytes and more, depending on the complexity of the expression. It takes more memory if different cell types alternate within one column. Plus formatting takes some memory. Conditional formatting more. Each Undo step takes memory, depending on what an edit changes and what the change affects.

Do the math: (60 sheets * (702 columns * 1000 rows = 702000 cells)) = 42120000 cells), with each cell at least 20 bytes = 842400000 bytes, plus 60 sheets * 256KB = 15360000 bytes, in total 857760000. Add text and formulas ... you're probably at 1GB to 1.5GB (or more). Check with your system's process viewer.

edit flag offensive delete link more
0

answered 2016-09-23 20:10:05 +0200

There aren't real limits the way you think (sure, there's a hard row and column limit; I think it was per sheet) and it it's closer to impossible to tell what factors it depends on.

For example, I've opened extremely massive OpenDocument files on one computer which didn't break a sweat, but another computer which could be way better than the previous one chokes even upon mentioning a fraction of that file.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-09-23 19:56:55 +0200

Seen: 199 times

Last updated: Sep 23 '16