After some recent upgrades (both OS and LibreOffice version), I find the Copy&Paste functionality of Calc has changed to always first paste values and copy formulas only on second try.
Example:
Cell A1 contains value 10
Cell B1 contains formula =A1, displays 10
Cell A2 contains value 55
Now if I mark cell B1, press Ctrl-C, then go to cell B2 and press Ctrl-V, I would expect cell B2 to contain formula =A2 and display 55. However it contains and displays 10. Even more funny, if I repeat the same (mark cell B1, press Ctrl-C again, mark cell B2, press Ctrl-V), it copies the formula and cell B2 displays 55. Maybe worth noting, that the first paste takes a lot longer (almost a second), whereas the second paste is instant.
Is the “intelligent I-know-better-than-you” paste a new feature? Can I turn it off?
And I do know about pulling that little marker at the edge of the cell or using Paste Special, this does not change that I would like Ctrl-C/Ctrl-V to work like it has always worked before and how it works in Excel (i.e. copy formulas and format by default)
LibreOffce version:
Version: 25.8.3.2 (X86_64) / LibreOffice Community
Build ID: 580(Build:2)
CPU threads: 8; OS: Linux 6.8; UI render: Skia/Raster; VCL: x11
Locale: de-DE (en_GB.utf8); UI: en-US
Ubuntu package version: 4:25.8.3-0ubuntu0.25.10.1
Calc: CL threaded
Thanks for any help.