So I find when I’m copying and pasting large files on LibreOffice Calc from one sheet to another, it won’t paste more than about 1900 rows and 4 columns of data at a time.
It just won’t let me do it.
Anyone else experience this? Just trying to figure out if just my system or something more general.
LibreOffice desk at documentfoundation.org says there should be a copy button on the ‘about’ popup, under menu/help/about but having used Libreoffice for well over a decade on two versions of Linux I’ve never seen anything other than this? Can anyone confirm that’s what they see too?
Just look behind version information the icon of the two pages is the copy button just click on it (you don’t get a message that it has copied something).
As you can see below mine seems to work.
Version: 25.2.2.2 (X86_64) / LibreOffice Community
Build ID: 520(Build:2)
CPU threads: 12; OS: Linux 6.14; UI render: default; VCL: kf6 (cairo+wayland)
Locale: nl-NL (nl_NL.UTF-8); UI: nl-NL
25.2.2-2
Calc: threaded
Not sure if this would help you but after much angst in finding that every time I tried to save a huge Libreoffice .xlsx file (1500 rows, 6 columns, somewhat similar to yours) it would take about 30-60 seconds.
Then I (oops) made a “mistake” NOT as an .xlsx but as the native Libreoffice .odf file, and poof, down went the waiting to < 1 microsecond. Every time. With each save.
So when I have to deal with the corporate Windoze world and Micro$oft I just do a Save As .xlsx … once only.
Hope that might work for ya too…
Also, a great bunch of Office software is from a German company named SoftMaker. Their Freeoffice products (Planmaker for the Excel/LOffice equivalent … has been working great for me. I kinda switched to that instead because it’s beautiful (for me) to work with. Won’t run on Silicon Macs though, as far as I can tell.
Good luck!
To the right of the version information is a poorly defined icon in the screen grab above it and looks like a tiny set of folders, and it does ‘click’ without giving any notice of what if anything has happened. The troubleshooter over on the LibreOffice side has not given much verbal description, except saying there should be a copy button.
I’ve bumped that icon a couple of times, so maybe it copied.
I have to talk to the other side to see if what I did is enough or if there is another step
Yes, I’m familiar with Softmaker, I have a licence for it, but I have a very large, highly customizer spreadsheet tuned for LibreOffice’s feature set.
The Softmaker product doesn’t quite do what I want.
I’m not having a speed problem on saves, the option to save is grayed out on copies over 2000 rows. Not slow, just forbidden.
There were changes to LibreOffice just recently to the copy & paste routines to make it more compatible with Google Office.
That when this problem surfaced.
Well hey I didn’t design this , just pointing you in the right direction.
And copy means copy and not send.
The save feature he’s trying to get me to use, doesn’t save it to my hard drive, it’s saving it somehow to where he can see it, at least that’s what he’s implying.
It’s more of a transmission, back to him.
Well this is something that was copied by clicking the copy icon of libreoffice.
Now I pasted the copy to the forum and it gets uploaded to the forum.
What you call transmission is probably just about the same procedure.
What I meant to say is clicking on the copy icon doesn’t automagically will take care of that procedure.
Oh, I see what you mean. That’s what he’s looking for.
I ran a test to see if I could replicate the issue for you (I wasn’t able to).
This is using LibreOffice 25.2.2.2 ( libreoffice-fresh).
Please, let me know if I’m misunderstood those steps.
Version: 25.2.2.2 (X86_64) / LibreOffice Community
Build ID: 520(Build:2)
CPU threads: 24; OS: Linux 6.14; UI render: default; VCL: kf6 (cairo+xcb)
Locale: en-AU (en_AU.UTF-8); UI: en-GB
25.2.2-2
Calc: CL threaded
It looks like you might be using libreoffice-still @mlytle0, which is ordinarily fine. But as you’ve encountered an issue, perhaps try installing libreoffice-fresh instead?
You beat me to it, @Bink. I was in the middle of making a post, and yours popped up. But yeah, I’d remove
still and install fresh, if it was me.
So maybe in the newer release in the fringier version this is already fixed.
It seems at least possible, and it’s simple enough to give it a go 
O.K. it’s late here in Houston, But on my wife’s machine, I deleted LibreOffice still and installed LibreOffice fresh. I also checked that she didn’t have a clipboard manager, and she doesn’t.
I run two machines of my own, one had clipman (as the file [
xfce4-clipman-plugin])(https://archlinux.org/packages/extra/x86_64/xfce4-clipman-plugin/), but I removed it for this troubleshooting as the LibreOffice support guy insisted this was the problem. The other machine, I use, never had that installed. In safe mode on all three machines, the bug is happening.
So 0 for 3, so far.
Tomorrow will be busy, as unfortunately she is moving to a care facility for her Parkinson’s so I may be out of pocket until Tuesday.
What happens if you paste the content into a basic text editor (is that Mousepad under XFCE?) ?
Does it successfully paste?
I don’t think I have mousepad, but I can install it for a test.
If there’s a basic text editor on your system, that’ll suffice I think. I just haven’t used XFCE, so I’m not sure what comes out of the box.
Under KDE Plasma (that I’m more familiar with), the equivalent would be Kate.
Mousepad and Gedit, nothing, of course this isn’t text, it’s date/time and numeric formats, but maybe that doesn’t matter.
I can paste to gnumeric from Libreoffice, if it’s over 2000 rows and higher, no problem, but I can only paste from Libreoffice to gnumeric if it’s 1900 rows or fewer.
I haven’t bothered to nail down what specific number the failure point in rows is, like 1942 rows or something like that.
