Maximum rows in calc 7

I have a spreadsheet with 32,400 rows of data. When I try to paste in another 4,300 I get a not enough space error. I thought this version could handle more than 1 million rows.

Check that you haven’t inadvertently added data in unexpected places. Use Ctrl + End to move the cursor to the last cell on the sheet that contains data.

Try selecting the 4300 rows (Ctrl+Shift+End from starting point to end of data) and copying that, rather than the whole sheet otherwise you are trying fit in 32400 more rows than a full sheet can contain.

Do not select the column, select the cells you want to copy.


to simply answer your question “maximum rows in calc 7”. There are 2 cases, which depend on settings:

[1] Tools -> Options -> LibreOffice -> Advanced -> [ ] Enable experimental feature (may be unstable and
[2] Tools -> Options -> LibreOffice Calc -> Defaults -> [ ] Enable very large spreadsheets (16m rows, 16384 cols)

(The latter option can only be set, if the first one is enabled)

Case 1 Both options are set

Maximum number of rows: 16 000 000 (16*106)

Case 2 Option [2] is deactivated

Maximum number of rows: 1048576 (220)

Hope this answers your question.