A shortcut for pasting unformatted text into Writer already exists - Ctrl + Shift + Alt + V. It's very convenient. Can a shortcut with the same functionality be incorporated into Calc for use with within-cell editing as well as whole-cell pasting?
Just tested with 184.108.40.206 on Bodhi Linux 2x and I'm able to do what I think you're trying to do.
Can you provide reproducible steps that aren't working for you as well as your OS and version of LibreOffice.
Marking as NEEDINFO - once you provide repro steps and the additional info mark as UNCONFIRMED. Thanks
Dear Bug Submitter,
This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INVALID
due to lack of needed information.
For more information about our NEEDINFO policy please read the
wiki located here:
If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.
Thank you for helping us make LibreOffice even better for everyone!
(In reply to Joel Madero from comment #1)
> Just tested with 220.127.116.11 on Bodhi Linux 2x and I'm able to do what I think
> you're trying to do.
> Can you provide reproducible steps that aren't working for you as well as
> your OS and version of LibreOffice.
> Marking as NEEDINFO - once you provide repro steps and the additional info
> mark as UNCONFIRMED. Thanks
Thanks Joel. Sorry for the delay. These are the steps to reproduce:
- Open a new document in Writer
- Type a short sentence. Format one or two words in the sentence differently. e.g. make bold, change font size
- Select sentence and copy.
- Add some extra lines.
- Press Ctrl+V to paste. Result: sentence is pasted WITH the formatting changes.
- Press Ctrl+Shift+Alt+V. Result: sentence is pasted WITHOUT the formatting changes.
- Open a new Calc spreadsheet.
- Press Ctrl+V. Result: sentence is pasted WITH the formatting changes.
- Press Enter to go to the next row.
- Press Ctrl+Shift+Alt+V. Result: the letter “V” is pasted, not the unformatted text.
(In reply to Tom Colley from comment #3)
please could you test with 18.104.22.168? I tried on windows and have little different results, but bad results.
> - Open a new document in Writer
> - Press Ctrl+Shift+Alt+V. Result: sentence is pasted WITHOUT the formatting
My result: sentence is pasted WITH the formatting changes.
> - Open a new Calc spreadsheet.
> - Press Ctrl+Shift+Alt+V. Result: the letter “V” is pasted, not the
> unformatted text.
My result: nothing pasted.
The steps to reproduce, and related results, as shown in Comment 3 by me were done with:
--- Ubuntu 14.04LTS (current long term stable version of Ubuntu)
--- LibreOffice 22.214.171.124. (latest version of LibreOffice compatible with that version of Ubuntu).
That is a false statement. LibreOffice 126.96.36.199 is perfectly compatible with Ubuntu 14.04. Just install the ppa - https://launchpad.net/~libreoffice/+archive/ubuntu/ppa
If you're unwilling to do this then bug goes to WORKSFORME. 4.2 is EOL and will no longer receive bug fixes.
Closing as WFM - if you test 4.3 or 4.4 and can reproduce, set the bug to UNCONFIRMED. Thanks
I have just tested for this bug with LibreOffice 188.8.131.52 running on Ubuntu 14.04LTS. The bug was reproduced using the steps in Comment 3 with the same results. I'm marking this bug as Unconfirmed as per administrator's request.
My result on Linux is like described in comment 3.
On Windows, ctrl-shift-alt-v does work ok in Writer (contrary to raal's experience).
In Calc, nothing happens (same as raal's experience).
Set to NEW.
Win 7 Pro 64-bit, Version: 184.108.40.206
Build ID: c4c7d32d0d49397cad38d62472b0bc8acff48dd6
Ubuntu 14.10 64-bit
Build ID: 40m0(Build:2)
Maybe it was fixed in one version. It works for me in LO 220.127.116.11 on Win 10.
Tested with draw und writer as source and calc as source. Worked after clicking in a cell for paste and only by choosing a cell. In both cases, the copied text was inserted as unformated text.
Confirmed working now on Linux as well.
Arch Linux 64-bit
Build ID: 6.0.6-2
CPU threads: 8; OS: Linux 4.17; UI render: default; VCL: kde4;
Locale: fi-FI (fi_FI.UTF-8); Calc: group
I just tested as per Comment 3 using:
- Linux Ubuntu 18.04
- LibreOffice 6.06.2
In Calc, I still get the same result when I press Ctrl+Shift+Alt+V: the letter “V” is pasted, not the unformatted text.
Pressing Ctrl+Shift+V provides a dialog box with the standard "Unformatted text" option. This delivers the required functionality in a two-step process which is fine. We've all got "bigger fish to fry", so leaving this as "Resolved - WorksForMe" seems appropriate.