Can't cut and paste formula in Calc, only text import dialog appears

mikeg · August 16, 2024, 2:52pm

I’m running into a new problem with

Version: 24.2.5.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 20; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 4:24.2.5~rc2-0ubuntu0.22.04.1~lo1
Calc: threaded

even if I use libreoffice --safe-mode I cannot natively copy and paste more than 1 row of cells. Previously this was not a problem. Currently, if I highlight cells and copy cells from more than 1 row, when I try to paste (Ctrl-v or Edit -> Paste) I get a text import dialog.

It might be irrelevant, but when I get the import dialog it defaults to UTF-16 encoding, but as you can see above my locale is set for UTF-8, which is what I would expect. I’m running MATE 22.04

Has anyone else had this issue or know how to trouble shoot it?

fpy · August 17, 2024, 5:17pm

you mean even from within Calc itself ?

what do you have in your System settings > Region & Language ?

mikeg · August 19, 2024, 7:43pm

For the computer itself I have the following

$ locale
LANG=en_US.UTF-8
LANGUAGE=en_US
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=
`
I don't see a GUI interface for 'System Settings' nor 'Region & Language'

fpy · August 19, 2024, 7:56pm

what’s your desktop manager?
Region & Language

mikeg · August 20, 2024, 1:25pm

Thank you for your continuing help on this.

I am not sure if this is the same as ‘desktop manager’, but I’m running MATE, so

$ echo $DESKTOP_SESSION
mate

According to MATE-tweak, I’m using Marco (Built-in XPresent) as my windows manager.

Does this help?

fpy · August 20, 2024, 1:52pm

seems there are a few copy/paste issues around mate…

do you just have problems with calc ?

mikeg · August 20, 2024, 1:57pm

Thanks for the link on the bug, though it seems CLI related. I am also having issues with impress where I select a column box from a slide and when I paste it it pastes it as an image. (I think, will double check, but either way it behaves differently than in the past.)

FWIW,

$ apt search clipboard | grep installed
 
WARNING: apt does not have a stable CLI interface. Use with caution in scripts.
 
atril/jammy-updates,jammy-security,now 1.26.0-1ubuntu1.1 amd64 [installed]
evince/jammy-updates,now 42.3-0ubuntu3.1 amd64 [installed]
evince-common/jammy-updates,jammy-updates,now 42.3-0ubuntu3.1 all [installed,automatic]
gir1.2-gpaste-1.0/jammy,now 3.42.6-1 amd64 [installed,automatic]
gnome-settings-daemon/jammy-updates,now 42.1-1ubuntu2.2 amd64 [installed,automatic]
gnome-shell-extension-gpaste/jammy,jammy,now 3.42.6-1 all [installed]
gpaste/jammy,now 3.42.6-1 amd64 [installed]
libclipboard-perl/jammy,jammy,now 0.27-1 all [installed,automatic]
libgpaste13/jammy,now 3.42.6-1 amd64 [installed,automatic]
mate-settings-daemon/jammy,now 1.26.0-1ubuntu1 amd64 [installed]
mate-settings-daemon-common/jammy,jammy,now 1.26.0-1ubuntu1 all [installed]
r-cran-clipr/jammy,now 0.8.0-1.ca2204.1 all [installed,automatic]
r-cran-reprex/jammy,now 2.1.1-1.ca2204.1 all [installed,automatic]
texlive-latex-extra/jammy,jammy,now 2021.20220204-1 all [installed,automatic]
x11-apps/jammy,now 7.7+8build2 amd64 [installed]
xclip/jammy,now 0.13-2 amd64 [installed]
xsel/jammy,now 1.2.0+git9bfc13d.20180109-3 amd64 [installed,automatic]

mikeg · August 20, 2024, 2:47pm

Well this is embarrassing, but I just rebooted my machine and the problem seems to have disappeared. Yippie. My apologies for taking your time with this. I nonetheless appreciated it.