https://bugs.documentfoundation.org/show_bug.cgi?id=162621
Bug ID: 162621
Summary: LibreOffice Calc - Paste Unformatted Text by
double-clicking in a cell
Product: LibreOffice
Version: 24.2.1.2 release
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: molnarszilar...@gmail.com
Description:
I already asked about this issue at
https://ask.libreoffice.org/t/libreoffice-calc-paste-unformatted-text-by-double-clicking-in-a-cell/108486?u=molnarszilard,
but did not get a definitive answer from a developer.
Previously, (up until version 24.2.0.3) if I copied a text (ex. from a browser)
and clicked on a cell in LO Calc, Ctrl+V would paste the text preserving the
formatting from the source (or ask me what to do with a pop-up window),
however, if I double-clicked on the cell, it would go into Edit mode, and now
Ctrl+V would paste the text unformatted.
In the newer 24.2.1.1 version, in both cases, the text will be pasted with the
original formatting (using only one click opens the Import Options pop-up
window as previously). If I want to paste the text unformatted, I have to
right-click on the cell->Paste Special → Unformatted Text. (Although, sometimes
not all of the formatting are kept, just a few, e.g. When I copy-pasting
something from the 'Enter A Bug' wepage, unless it is a link, the pasted text
is no longer colored or bolded, only the font is kept - Liberation Serif over
the cell default Liberation Sans).
It was quite convenient to double-click on a cell, and then use Ctrl+V to paste
the text unformatted.
Is this a bug or is there a setting that could get the previous behavior back?
(As a workaround I tried to switch the shortcuts Ctrl+V with Shift+Ctrl+Alt+V.
In this way, single-click on the cell then `Ctrl`+'V' would paste the
unformatted text, while double-click (or single-click+`F2`) and then `Ctrl`+'V'
would paste the formatted text. I will see how much I can get used to this -
actually, might be even better.
However, this is only a workaround (which usually does not mean that the
original issue is resolved), and other user might also try to search this
issue. I consider this issue as resolved if the original behavior is restated,
or a developer says, that the new behavor is intended.)
Steps to Reproduce:
1. Create a new Spreadsheet
2. Copy a formatted text from somewhere (e.g. a webpage)
3. Double-click into a cell (or single-click then F2)
4. Press Ctrl+V
Actual Results:
The copied text is pasted with the original formatting
Expected Results:
The copied text is pasted with the default formatting of the cell
Reproducible: Always
User Profile Reset: No
Additional Info:
I have this issue on Ubuntu 20.04 (installed on a computer), and on Debian 12
(live environment), and someone else reproduced this issue on Windows
https://ask.libreoffice.org/t/libreoffice-calc-paste-unformatted-text-by-double-clicking-in-a-cell/108486/4?u=molnarszilard
--
You are receiving this mail because:
You are the assignee for the bug.
