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.

#9

Still and issue in V25.3.2.3

Someone try and paste the contents of column K over the top of column A. Or anywhere for that matter.

Untitled 1.ods (1.2 MB)

#10

Dare accepted.
Place cursor in K2
Shift+Ctrl+Down arrow to select data in K
Ctrl+C to copy
Cursor to L2
Ctrl+V to paste
Et voila
Untitled 1a.ods (1.3 MB)

Version: 26.2.1.2 (X86_64)
Build ID: 620(Build:2)
CPU threads: 16; OS: Linux 6.12; UI render: default; VCL: x11
Locale: en-AU (wbp_AU.UTF-8); UI: en-US
SlackBuild for 26.2.1 by Eric Hameleers
Calc: threaded
#11

Followed your exact steps, doesn’t work.

Copying approx. Half the range works

TBH, this spreadsheet has started becoming frustrating as soon as it grew a bit in size.

I’ve run into the “removing duplicates taking 5 minutes” issue as well, all things Excel 2007 handles almost instantly

Is there any more diagnostic data I can provide?

Surely this isn’t something that’s been fixed between V25 and V26

Right click, even after copying the range again, and the context menu shows nothing in the clip board

IMG_20260312_215618_162
IMG_20260312_215618_1621000×750 234 KB

#12

image

#13

And your actual Linux distro is? What desktop environment? Is there a clipboard manager involved?

For future info, that icon to the right of Version Information allows you to copy the information as text to your clipboard; no need for screen capture etc.

1 Like
#14

Debian Trixie, XFCE, x11, nothing funky regarding the clipboard to my knowledge. The install is not that old. Hardware is a bit i5-3210M. Issue persists after a restart, and also after deleting all sheets but sheet 5.

Scrolling is chuggy, attempting to paste into M2684 (avoiding the scroll) also fails

#15

OK I found the precise limits.

1,920 rows and above will not paste. Whether its taken from column K or another column.

1,919 rows will paste, taken anywhere in in the sheet, with any selection of columns (ie K2:K1920 or A590:K2508 both work)

The limit seems different on the “NoRequests” Tab. 1,649 rows.

Moving back to Sheet5 its 1,919 again.

This is so strange.

What is most peculiar is Sheet5 was generated by applying an AutoFilter to data in the Requests sheet and dumping it out in one go

Just tried a brand new sheet with random numbers and 2,500 rows will not paste

What is going on?? This is such a weird bug

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