Paste Behaviour Changed

[O_Nyeesu]

Hi. The paste behaviour in Calc* seems different to previous versions I have used. Normally the paste behaves as follows:

1. Single-click a cell & paste into it = it brings the source formatting into the cell.
2. Double-click a cell & the cursor appears, paste there; it pastes as unformatted text.
3. Paste into the formula bar at the top = it pastes as unformatted text.

Option #2 seems to have stopped working. It brings formatting with it, same as #1. I prefer the old behaviour, is this a bug or can I regain the previous behaviour? I know I can right-click & Paste Special, but this isn’t as convenient. Thanks for any suggestions.

*Version: 25.2.3.2 (X86_64) / LibreOffice Community
Build ID: 520(Build:2)
CPU threads: 8; OS: Linux 6.12; UI render: default; VCL: kf6 (cairo+wayland)
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Debian package version: 4:25.2.3-2+deb13u3
Calc: threaded

[mikekaganski]

In which version was #2 working differently?
Just in case, I tested OpenOffice.org version 1.0.3 (2002), and it worked the same:

[LeroyG]

@O_Nyeesu

2. Double-click a cell & the cursor appears, paste there; it pastes as unformatted text.

This is (partly) true only if the source are more than one cell.

[O_Nyeesu]

It is when pasting text from Firefox. I paste order number from there into a spreadsheet to keep track of them.
The previous version where it worked (i.e. pasted plain text in method #2) was v7.4.7.2 (Debian 12).
The version where method #2 now brings (some) formatting with it is v25.2.3.2 (Debian 13).

Attached is screenshot of pasting in v25.2.3.2 via the 3 methods. Taking a bit of text from a website link.

It is as if it maintains the font but not the bold attribute in method #2.
Method #3 drops both those attributes.

[mikekaganski]

The change happened with the fix to tdf#157363.

[O_Nyeesu]

Thanks. It is unfortunate that a fix for Impress to make it behave like PowerPoint makes Calc behave differently to how it used to & to how Excel works (I’ve just tested that too). Excel behaves as per my 123 methods above. The new #2 behaviour isn’t as convenient for my workflow. In Calc I would expect URLs & formatting to be maintained only via method #1. Number 2 is a quick & convenient way to paste plain text & is preferable to using #3* or right-clicking & Paste Special or using shortcut keys.
*Using the formula bar is best for editing formula or long text strings, not as the new way to paste plain text. In my opinion, others will no doubt disagree.
Thanks.

[mikekaganski]

Note that #2 was never intended as “insert plain text” - as I demonstrated. It accepted RTF, when it was in the clipboard. It just so happened, that it didn’t know about HTML; and specifically data from browser didn’t contain RTF, but only HTML. So - what you enjoyed previously was a bug (missing support for one particular rich format). And how Excel works is different; in Excel, the active cell editing really only accepts plain text. So the similarity was pure coincidence.

Note also, that the fix was not only for Impress; it explicitly mentioned Writer, Calc and Draw.

[O_Nyeesu]

Ah right, thanks. My misunderstanding. It would be nice if method #2 did behave as per how it previously did though (ignore HTML). If there was a setting to make it behave as such it would be handy, if possible as a development. If not I’ll just have to get used to it, thanks.

[mikekaganski]

That would be an enhancement request (everything is possible).