On 7/9/25 03:27, Andrea Venturoli wrote:
Hello.
I'm not sure this is the right place to discuss this, as I'm not sure
this is a problem of mine, a port problem or an upstream problem...
Recently, when using LibreCalc, if I copy a cell with a formula and
paste it, I get a cell with the plain value.
A subsequent second copy&paste will copy the formula.
The "problem" will repeat again at the next chance.
Is anyone else experiencing this?
libreoffice-25.2.3.2_1, kde-6.3.5.25.04.2, xorg-7.7_3, FreeBSD
14.3-PRERELEASE stable/14-n271132-a516440afdd3 GENERIC amd64 with a new
document and a quick test I get proper copy first time with keyboard
ctrl+c, ctrl+v though it was just after entering the values.
Where does this behaviour come from?
To get the effect you describe you would need to use something like
'values only' from 'paste special' (ctrl+shift+v). A direct 'paste
unformatted text' is available as ctrl+alt+shift+v.
Browsing Tools>Customize... you could look for assigned hotkeys. The
keyboard tab separates calc from libreoffice as a whole so you may be
looking in more than one area; the first tab may be worth reviewing and
easier to browse.
As you describe the effect as intermittent, I'd also wonder if there
was macros involved or failing hardware sending stuck keys that change
the response; hardware issues likely doesn't apply if using mouse based
copy+paste, but I don't normally do that.
Have you repeated this on a new document (macros and some settings
store in each document)? Have you repeated this on a fresh LibreOffice
profile (likely data managed by ~/.config/libreoffice)?
Wondering if other software could also interfere and manipulate the
clipboard between copy and paste. I haven't tracked code but it seems
like LibreOffice uses its own understanding of the clipboard contents
until the clipboard is altered outside LibreOffice; that lets it keep a
formula for its own pasting but present the value alone to other
programs to paste. Could try isolating to a very basic window manager
and no other programs open in it to reduce outside clipboard influence.
bye & Thanks
av.
