Re: LibreOffice copy&paste formulas

On 7/9/25 19:33, Edward Sanford Sutton, III wrote:
> On 7/9/25 03:27, Andrea Venturoli wrote:

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

Thanks.



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

I'm using plaint Ctrl-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.

Ctrl-V is paste (as the default).



>    As you describe the effect as intermittent,

It's not systematic, but happens almost everytime:
1) Ctrl-C on a cell with a formula;
2) Ctrl-V on another cell and a plain number is pasted;
3) Ctrl-C on the same cell as 1);
4) Ctrl-V on cell 2) and the formula is pasted.



> I'd also wonder if there was macros involved

On all documents???
How do I check?
I looked into Tools->Macro and found nothing strange, but I'm no expert.



> or failing hardware sending stuck keys that change 

This happens on two computers, so no again.



>    Have you repeated this on a new document (macros and some settings 
> store in each document)?

Yes and it shows.



> Have you repeated this on a fresh LibreOffice 
> profile (likely data managed by ~/.config/libreoffice)?

I tried now several times and I was NOT able to reproduce the problem.
I'll try for a while with a new profile.
I didn't have that much customization, really.
Hope this doesn't come back someway.




In any case thanks.

  bye
	av.