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.
Hello
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.