Bug 65872 - EDITING: LibreOffice should not prompt with dialog every time the Paste keyboard shortcut or menu paste option is chosen
Summary: EDITING: LibreOffice should not prompt with dialog every time the Paste keybo...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: high normal
Assignee: Not Assigned
Whiteboard: BSA
Keywords: difficultyMedium, easyHack, skillCpp, topicDebug
: 101880 (view as bug list)
Depends on:
Blocks: Paste
  Show dependency treegraph
Reported: 2013-06-17 22:48 UTC by David
Modified: 2020-10-15 04:10 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description David 2013-06-17 22:48:35 UTC
Problem description: 
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
3. ....

Current behavior:
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. 

Expected behavior: 
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: release
Last worked in: 3.5.0 release
Comment 1 retired 2013-06-25 22:08:21 UTC
David thanks for the report.

I can confirm this behavior in LO, 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.
Comment 2 retired 2013-06-25 22:08:30 UTC Comment hidden (obsolete)
Comment 3 aliceflore 2013-07-30 12:52:36 UTC
Also with LibreOffice in Linux Mint 15. Not in Windows 7.
Comment 4 Joel Madero 2013-10-29 01:58:24 UTC
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
Comment 5 Dan Essin 2014-12-16 07:18:09 UTC
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.
Comment 6 Björn Michaelsen 2014-12-18 10:16:10 UTC Comment hidden (obsolete)
Comment 7 Geoffrey Skinner 2015-08-14 16:36:59 UTC
In addition, it would be helpful to have the default paste option as a user preference
Comment 8 Joel Madero 2015-08-14 17:01:33 UTC
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
Comment 9 JD 2016-04-12 19:07:28 UTC
I can confirm this is happening in Version:
Build ID: 89f508ef3ecebd2cfb8e1def0f0ba9a803b88a6d
CPU Threads: 4; OS Version: Linux 4.1; UI Render: default; 
Locale: en-US (en_US.UTF-8)
Comment 10 Buovjaga 2016-09-24 17:01:08 UTC
*** Bug 101880 has been marked as a duplicate of this bug. ***
Comment 11 Naj 2017-08-28 16:39:09 UTC
Optional workarounds:
- 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
Comment 12 amykyta 2017-09-11 04:44:51 UTC
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!
Comment 13 samiam 2018-04-30 20:46:18 UTC
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.
Comment 14 Shawnix 2018-07-07 14:35:55 UTC
I can confirm that this issue persists to version running on Linux.

It has been more than 5 years since David first reported the issue.
Comment 15 Eric Davelaar 2018-08-17 19:34:41 UTC
Still an issue in Version on Linux.
Comment 16 Asia Danmore 2018-09-03 21:51:57 UTC
This is still happening on Version: on Mac. Terrible bug has probably cost thousands of hours or more of productivity worldwide
Comment 17 Lonn Holiday 2018-10-13 01:12:40 UTC
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?
Comment 18 Xavier Van Wijmeersch 2018-10-13 14:32:18 UTC
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
Comment 19 Marcel Partap 2019-03-28 18:12:02 UTC
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.
Comment 20 Mike Kaganski 2019-08-09 07:51:28 UTC
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...
Comment 21 ffs 2020-10-07 16:39:23 UTC
Please someone stop this horrible behaviour it makes one of the most marvellous time saving gui inventions (middle click paste) and turns it into a horribly frustrating waste of time.
Comment 22 Mike Kaganski 2020-10-08 06:20:17 UTC
*** Bug 137316 has been marked as a duplicate of this bug. ***
Comment 23 Mike Kaganski 2020-10-14 08:23:34 UTC
Code pointers:


The implementer of a new "do not show again" option must add a check for the new option being set, and if it is, read ScAsciiOptions from saved values, instead of from the dialog.