LibreOffice should not prompt with dialog every time the Paste keyboard shortcut or menu paste option is chosen.
Steps to reproduce:
1. Copy a number to the clipboard from a website
2. Paste that number into the spreadsheet
Pasting into the dialog you currently get a dialog that says "Select the language to use for import" and you must chose - EVERY TIME YOU PASTE - Automatic or Custom. This is new bad behavior as of 3.6. It never used to prompt me for this.
Pasting should never ever prompt with a dialog, but even if it does, it should be a setting that can be remembered. My language never changes, I always want the option to be automatic. You offer no option to remember the choice in the dialog and you offer no option in the preferences dialog to set and remember the choice.
Users copy and paste things from websites sometimes hundreds of times a day. By forcing this dialog on every paste, you are causing the user hundreds of extra unnecessary keystrokes. That is wrong. You should give the users the ability to paste without being bombarded with a dialog box every single time. The dialog box should remember my choice or I should have preference I can set in the preferences to remember my choice.
On a related issue - In addition, in Excel, the default for paste should be to paste unformatted text. Pasting formatted text totally messes up the formatting of the spreadsheet. I know about the ctrl-shift option - but there I am once again presented with an unnecessary dialog and I must choose unformatted text - it should be obvious I want unformatted text with that keyboard shortcut.
Operating System: Mac OS X
Version: 18.104.22.168 release
Last worked in: 3.5.0 release
David thanks for the report.
I can confirm this behavior in LO 22.214.171.124, OS X 10.8.4.
The dialogue is annoying, but if decided to display it, it should have a checkbox (set to "on" by default) that allows LO to remember this setting for all future pasting.
Setting to NEW.
Also with LibreOffice 126.96.36.199 in Linux Mint 15. Not in Windows 7.
I have tested this all the way back to 3.5beta0 and can confirm it all the way back to that point. Without a version that is known to work I am removing regression from keywords
what an absolutely horrible "feature". Who could have possibly thought that this would be of any use under any circumstance. It's practically a show stopper. As much as I have been trying to avoid using MS Office, I may have no choice.
I can't believe that after all this time and all the negative comments, someone has not fixed it. I would, but my programming skills are not up to the task as a one-off.
(This is an automated message.)
LibreOffice development currently prioritizes bugs with the so called MAB (most annoying bugs) -- as this bug has not run through that process (including writing a short rationale for this bug being a candidate and other who are watching the tracker bug silently approving that rationale etc.) its priority is set to high. Note this is effectively no change in the urgency assigned to this bug, as we are currently not making a difference between high and highest and severity is untouched.
You can find out more about MABs and how the process works by contacting libreoffice qa on irc:
The QA wiki page also gives you hints on how to get in contact with the team (if IRC fails you, your next best choice is the mailing list):
In addition, it would be helpful to have the default paste option as a user preference
Please don't add different enhancement requests to this bug - the last one is completely different and should be a different bug report....despite them being related we have a policy of 1 bug per report. Thanks!
You can add the new bug report in the "see also" field so that devs know they are related
I can confirm this is happening in Version: 188.8.131.52
Build ID: 89f508ef3ecebd2cfb8e1def0f0ba9a803b88a6d
CPU Threads: 4; OS Version: Linux 4.1; UI Render: default;
Locale: en-US (en_US.UTF-8)
*** Bug 101880 has been marked as a duplicate of this bug. ***
- Create a macro to do the operation, probably best option
- Alt+key combinations, assign "Edit/Paste Unformatted Text" to Alt+V
- Use ctrl-alt-shift-v
- Double click the cell instead of single clicking, then ctrl-v paste
Each has limitations, which are, respectively:
- Have to manually create macro, per user
- Have to manually create, per user
- Have to have very dexterous hands, or use both hands
- Pastes untrimmed leading whitespace
Confirmed that this is still an issue in:
Build ID: 1:5.4.0~rc3-0ubuntu0.16.04.1~lo1
Any updates on this? I'm surprised that such an annoying issue has been around for 4 years!
I constantly copy and pasting into Office documents and this infuriating "feature" is the only reason Microsoft Office is still installed on my system. Please provide a way to disable this dialog box permanently.
I can confirm that this issue persists to version 184.108.40.206 running on Linux.
It has been more than 5 years since David first reported the issue.
Still an issue in Version 220.127.116.11 on Linux.
This is still happening on Version: 18.104.22.168 on Mac. Terrible bug has probably cost thousands of hours or more of productivity worldwide
Over five years!?!
Sorry I'm being such a whiner but please someone on the libreoffice team fix this. How do we make this happen?
use paste special and then that dialog wont popup
some workarounds are used, see comment11, in the paste special options
Build ID: fd41fb8392a4e9a27d9fd09071a5f1e2be4b5a0e
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4;
Locale: nl-BE (en_US.UTF-8); Calc: threaded
This dialog should not even exist; 'automatic' should be the default and all the options in there should go to the 'paste special' dialogue.
Does this need a bounty for someone to implement it, or what is causing the delay fixing this issue of
> Importance: high
? If there is a lack of clarity among you LO devs, please inquire.
As fat as I can see, this is Linux-only problem? That is mentioned in the meta here, and also all references mention Linux here (and comment 3 explicitly mentions no problem on Windows).
IIUC, the said behavior is normal *when plain text clipboard format is used to paste*. Usually, copying something from web pages produces multiple formats available in clipboard, including HTML (here on Windows), so LO *by default* chooses HTML as most rich... and doesn't ask for import options.
Does copying a web stuff produce plain text only in clipboard on Linux? Or maybe some clipboard manager does it?
Pasting plain text should always produce the said dialog (because there's pasting CSV-like stupp use case); the only optimization possible here is maybe checking if the clipboard content is a single word...