Re: LibreOffice copy&paste formulas

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.
>