Paste copied cell-content to multiple cells does not work anymore

That is not my style.
You are what you are.
.
Not much more to say.

Can I simply request we edit these comments for proper language? I don’t want to flag them (from erAck or emax). We have a community to maintain here.

I have no objections.

I really don’t care, things are like they are, but if it makes others happy… I beeped every beep in my post.

Maybe I didn’t understand: Who is ‘we’? Am I to edit this?

Yeah, I just meant to get rid of the hotter words yourself. I know that other have edit privileges, but I wasn’t thinking about that.

Well, I have an orange edit-pencil on top of the affected postings, but clicking this only shows kind of a history side by side. I can not change something. An the ‘edit’ - pencil at the bottom of the posts isn’t visible.

Am I missing something?

Maybe it’s the thought that counts; don’t sweat it. I don’t know why you aren’t seeing the edit icon, unfortunately. I assume you can edit some other post…I mean open for editing even if you don’t change anything? Unless something has been flagged already? (Not by me).

Try clicking the three dots below the item to be edited - which have a tool tip show more - and select the pencil?

1 Like

I just tried the three dots, but no success. They just expand horizontally and show a “bookmark” and a “share link” icon and that’s it.

Maybe it’s the thought that counts; don’t sweat it.

I agree.

In order to ease your pain, I can confirm that this problem is real

Fedora 34
LibreOffice version

Version: 7.1.8.1
Build ID: 10(Build:1)
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: kf5
Locale: en-IE (en_IE.UTF-8); UI: en-US
Calc: threaded

It seems that I can paste ranges normally within a sheet, but not from one sheet to another.

I tweaked the clipboard settings. No change.

Furhermore. I can paste selections from outside Oocalc. The problem exists only when pasting from one sheet to another.

Hi there, just wanted to confirm I also have the issue with pasting a simple text or anything ( like a check box) to multiple cells. But I am on Windows 10… Would appreciate it , if someone knows a fix. I don’t think I could see a solution in this thread…
Greetings

If you log on with a Microsoft Account and you enable Clipboard History with Sync across devices enabled (Start menu > Settings > System > Clipboard > Clipboard history) then you are likely to have problems with copy and paste.

Possibly the issue exists only with Sync across devices, if you can disable only that, see if it works. Otherwise disable Clipboard History or login with local account

Tested in Fedora 34, Plasma desktop.
Libreoffice calc version
Version: 7.1.8.1
Build ID: 10(Build:1)
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: kf5
Locale: en-IE (en_IE.UTF-8); UI: en-US
Calc: threaded

In Clipboard settings in SystemTray, disable ‘Synchronize the contents of the clipboard and the selection’. Tweaking the ‘Actions’ settings has no effect.
Thanks @emax for the pointer to right direction. This really was an annoying ‘feature’

Thank you for the feedback.

Be prepared, that this tweak will not finally solve the problem. It comes and goes, with or without other applications running.

Recently, I could just “solve” the problem with just clicking “defaults” in the clipboard configuration dialog. Later then, the problem was back and disabling ‘Synchronize the contents of the clipboard and the selection’ “solved” it again.

?

Copy & Paste in LO doesn’t show a reproducible or stable behavior on my machine. Other applications don’t have this problems here. None of them.

I tried couple of times and I am able to repeat the problem by enabling ‘Synchronize the contents of the clipboard and the selection’, so at least for my case there is some kind of observable consistency. Keeping my fingers crossed.

1 Like

can confirm on Kubuntu 20.04 and that fixed it for me.

Thanx for asking about this emax. It has been annoying me for about 2 years now. I got fed up again and came looking for a clue on what might be going on, and found this slightly intemperate thread.
The clue that it was to do with ‘anything that manages/changes selections’ was vital. Turns out that the ‘clipman’ plugin for xfce (xfce4-clipman-plugin on debian) has an option under ‘clipman settings’, called ‘Sync mouse settings’. That needs to be off to allow pasting into multiple cells to work. With it on, libreoffic shows the ‘text import’ dialog which you normally see when loading a CSV file.
The problem I have is that I need that setting ‘on’ for mouse-selection pasting in any electron-based application (such as Revolt, a matrix client).
So I do now have a workaround, but can someone explain exactly what’s going on so that we can work out what it would take to make clipman and libreoffice and revolt all interoperate correctly (assuming that this is possible).
Presumably clipman is changing the selection so that librecalc thinks it is a ‘new’ multi-line selection that needs parsing into the sheet, rather than the single- (or multi-) line selection that was made in itself and just needs copying.

Selection-buffers is a complicated business, but this feels like it should be possible to make this work, or at least decide which of the 3 programs is doing the wrong thing. (Actually Electron definitely is - the clipman ‘sync things’ option is only needed because electron always pastes the ‘ctrl-C’ buffer, not the mouse selection buffer. But turning that on seems like it shouldn’t be enough to break libreoffice.
So what is the hueristic/mechanism LPO uses to identify an external paste vs it’s own internal selection? And can clipman be made to interoperate?

  1. The “LPO” likely stands for LO.
  2. The way to solve (or at least learn) this would be to create a bug report, and there explain all the details regarding the necessary environment to reproduce the problem; provide a sample document and explain what specifically needs to be selected, how the copy must be performed, etc. - basically, imagine that you write that to a clueless person, who doesn’t have to know anything about computers to be able to follow the steps. This would enable people to see it; if there will appear a developer who wants to invest time into that, they would be able to debug it.
  3. You wrote your question as a solution. Was that text a solution?

In the meantime I have installed a new version of Ubuntu where I get this LO version information:

$ libreoffice --version
LibreOffice 24.2.6.2 420(Build:2)

This is, if I understand the Ubuntu version scheme correctly, a newer version than the one I had before.

To make a long story short: everything now works as expected. With and without Citrix, without any tweaks. My HOME directory content is the same as before, without any configuration changes on my part.

Maybe the cut&paste implementation of LO has been changed or a bug fix has been made, I don’t know.

In any case, on my side everything is exactly as it was before. :man_shrugging: