Unable to add more than 1000 rows

English
#1

Hi,

I am unable to add (copy and paste from another sheet) rows to a column past row 100. I have 18000 rows I want on one sheet.

Here sis what I have tried:
Created a totally new file and copy and pasted date into it - doesn’t work
Created a new sheet in current file and copy and past into it - doesn’t work
Copy and past into current worksheet - doesn’t work

Is there a setting I don’t know about? Everywhere says you can add 1000.000 rows!

Any suggestions will be appreciated thanks

I am running windows 11, LibreOffice version = 7.6.4

#2

any try works for me with 1000000 random numbers in a column!

#3

Thanks @karolus however, you have not explianed what you have tried

#4

any of your tries works for me:

#5

What is the range size of the source you are copying? (columns and rows)

In which cell are you pasting?

What is your last row occupied?

#6

Thanks for getting back to me guys.

If I copy the whole coloumn and try to paste it into the sheet it doesn’t work.
If I copy all the rows (maximum 1000) and try to paste them in, it doesn’t work either.
However, if I copy all the cells (click A1 - hold down shift and click last cell) I am able to paste in the new sheet.

Is this the only way, or should I be able to copy a whole column or rows?

I’ve now achieved what I was set out to, just curious for future reference.

Cheers

#7

There are 1048576 rows in a column. If you select an entire column and try to paste it in cell A2 you will get a warning There is not enough space on the sheet to insert them because you need 1 more row than the spreadsheet can contain, that is, you need 1048577 rows because you aren’t starting at the start of the column. The same applies to rows, you cannot copy an entire row and paste into cell B1, there won’t be enough room for an entire row plus one cell. This applies to all spreadsheets

If you have a contiguous range then click in the top left of the range you want to copy and press Ctrl+Shift+End then copy. Otherwise, click in the top left of the range, hold down Shift and click in the bottom right of the range and then copy.

1 Like
#8

Thanks for confirming. Will keep that in moind going forward.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.