How to "Paste Unformated Text" in Calc reliably?

[aiki2021]

Hello,

since a while pasting text just as unformatted text (all formatting striped down) in Calc has got really tricky and unpredictable.
Are there tricks or hints to make it more reliable?

I’d like any however formatted text to be pasted as pure text without any formatting
I’ve changed the assignment of “CTRL + V” to " “Paste Unformatted Text” to do so.
Still quite often pasting something copied from an internet browser is pasted somehow formatted. Mostly it is a different font and size.
Strangely if I select right mouse click “Paste Special” → “Unformatted Text” then it works like it supposed to work. Maybe also because I try it after the failed “CTRL + V” attempt.
It maybe depends on the original formatting too.

Is it possible to always trigger pasting plain text only if I’m in the input modus of a cell?
Basically typing something in the cell and then “CTRL + V” paste unformatted text.
Same behavior which works in MS Excel to avoid pasting formatting too.

Regards

Version: 26.2.2.2 (X86_64)
Build ID: 1f77d10d6938fd34972958f64b2bcfa54f8b1ba5
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: threaded

[fpy]

related …

Copy pasete issue with writer unwanted blank lines

Without the original web site it is hard to compare. There is one readily available, this one. If I copy the question here I get a possibly unexpected line break (normal paste) or paragraph break (unformatted text) for the first line, why? Because it was in the original, inserted by the author, see attached but turn on formatting marks View > Formatting marks (Ctrl+F10) PasteFromWebSite133995.odt (33.2 KB) The pastes are the same for 26.2.2.2 and 7.6.7.2

[aiki2021]

Hello,
quite good at least partially reproducible is i.e. Wikipedia

Saint-Émilion

In Firefox marked the “Saint-Émilion” title.
CTRL+V in Calc works like it supposed to (for me font size 10pt).
If I double-click into the cell with the pasted value to CTRL+V paste the same content again it is pasted formatted with font size 22 pt and bold.

[karolus]

@aiki2021

again it is pasted formatted with font size 22 pt and bold.

press ctrl+m after ctrl+v

[aiki2021]

It happens actually if you are in the editing mode in the cell (double click and cursor blinking in the cell).

ctrl-m is quite good hint, still it is bug for me.
“Again” means it is a known issue which not supposed to be fixed?

[EarnestAl]

@aiki2021

I’ve changed the assignment of “CTRL + V” to " “Paste Unformatted Text” to do so.

Did you change it for LibreOffice, for Writer, or for Calc?

@aiki2021

If I double-click into the cell with the pasted value to CTRL+V paste the same content again it is pasted formatted with font size 22 pt and bold.

If you paste normally into the formula bar then it will paste as unformatted text

[aiki2021]

@EarnestAl

Did you change it for LibreOffice, for Writer, or for Calc?

Calc and LibreOffice

[aiki2021]

@EarnestAl

If you paste normally into the formula bar then it will paste as unformatted text

Nice hint, but also a bit too complicated.