Bug 34686 - Option to turn off Paste mode for Return
Summary: Option to turn off Paste mode for Return
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.0 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
: 39531 (view as bug list)
Depends on:
Blocks: Paste
  Show dependency treegraph
Reported: 2011-02-24 18:54 UTC by Dakov
Modified: 2019-09-09 11:25 UTC (History)
6 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 Dakov 2011-02-24 18:54:10 UTC
If you copy a cell (ctrl+c) and then want to edit another cell before pasting - you of course press Return to edit that other cell - but LibreOffice has confusingly changed the behaviour of Return (toggle edit mode) and frustratingly PASTES the copied content into that cell instead of editing it.

This is obstructing and a daily frustrating.
Comment 1 Don't use this account, use tml@iki.fi 2011-03-08 00:23:14 UTC Comment hidden (no-value)
Comment 2 Kohei Yoshida 2011-03-08 05:22:12 UTC
Yes, this is 100% intentional.  You can hit ESC to get out of the paste mode.  As this is an essential part of LibreOffice Calc's internal, there is unfortunately no way to turn this off even as a configuration option (lots of other features depend on this one).
Comment 3 Dakov 2011-03-08 05:52:51 UTC
Thanks for the workaround - Escape - to be able to edit cells by without pasting into them.

Please consider an option to turn off Return for pasting. Copy mode is good (the highlight is a great feature) - but pasting with Return is dangerous.

I really hope you will consider changing this issue into an enhancement as it totally obstructs the workflow for some users (me and my colleagues). I haven't experienced this in Open Office or other spreadsheet programs.

It's suprisingly often that I work while having something important in the copy buffer and suddenly find out I've pasted it into a wrong cell since I edited a couple of cells before pasting. Really dangerous actually :(
Comment 4 Kohei Yoshida 2011-03-08 06:17:01 UTC
Sorry.  Like I said, no.  And you can always Ctrl-Z to undo accidental pasting.
Comment 5 Kohei Yoshida 2011-03-08 06:23:06 UTC
Well, maybe we should leave this open just in case.  But the chance of us working on making it configurable is pretty slim.  I'm just being honest about this.
Comment 6 Dakov 2011-03-08 07:15:37 UTC Comment hidden (obsolete)
Comment 7 Kohei Yoshida 2011-03-08 07:23:35 UTC Comment hidden (obsolete)
Comment 8 Dakov 2011-03-08 07:28:24 UTC Comment hidden (obsolete)
Comment 9 Kohei Yoshida 2011-03-08 07:33:55 UTC Comment hidden (obsolete)
Comment 10 Dakov 2011-03-08 07:37:17 UTC Comment hidden (obsolete)
Comment 11 bstern 2012-04-21 14:04:39 UTC Comment hidden (obsolete)
Comment 12 daniel.schaaaf 2012-09-13 08:24:48 UTC
Wow, the arrogance dripping from some of these comments here!

There are obviously some people who use Enter to edit cells! Otherwise we wouldn't have bug reports on it (this one and https://bugs.freedesktop.org/show_bug.cgi?id=39531 ).

@Tor Lillqvist
It is not a slight change for some users and it is not "a step forward in evolution". It is merely a copy of MS Excel's behavior.

@Kohei Yoshida
You stated that the new paste behavior is 100 % intentional. Would you mind to elaborate why it was introduced?
What is the difference for users between using Enter and Ctrl+v? If you use Ctrl+c to copy, then Ctrl+v is much easier to reach than Enter. If you use the mouse for copying, then the keyboard is irrelevant.
The "Enter to edit" behavior in Calc is present as "F2 to edit" in Excel, and it is inferior because Enter is close to Backspace and Delete, it is a bigger key than others and more difficult to miss than F2 (oh the joy from accidentally hitting F1).
You even copied the "Remove content from clipboard after paste" from Excel! Something that is driving me crazy in Excel, and one of the reasons I turned to Calc! And again, there is not reason for this behavior since we live in times of cheap RAM and, quite frankly, items in the clipboard are probably the smallest problem of LibreOffice's memory footprint.
Introducing the new behavior does not give us any usability enhancements! Instead, it destroys some people's work-flow!

I deeply respect everyone who contributes to LibreOffice and I deeply admire people who know how to program software. But we users are part of the package too! If you cannot introduce a change in behavior without adding an option to turn it off, then don't introduce it! We have "Enter to edit" as an option, please respect that. (And don't get any ideas and remove that option to force your view of what is right and wrong upon others.)
Peace! (And ... breathe.)

Btw., what other features of Calc depend on "Enter to paste"?
Comment 13 daniel.schaaaf 2012-09-13 08:31:03 UTC
*** Bug 39531 has been marked as a duplicate of this bug. ***
Comment 14 Dan H 2014-04-24 15:04:03 UTC Comment hidden (obsolete)
Comment 15 Dan H 2014-04-25 09:04:58 UTC Comment hidden (obsolete)
Comment 16 Dan H 2014-04-29 09:28:37 UTC Comment hidden (obsolete)
Comment 17 Jonathan Addleman 2014-04-29 12:14:47 UTC
I just wanted to chime in to say that I would love to be able to turn this off. Hitting enter to paste is a very strange mechanic, and one that's hard to predict. Especially when there's an option explicitly saying that enter should edit the cell instead! Maybe it's copying an existing behaviour in excel, maybe some people expect it, but I don't think it's intuitive at all. I would love to see an option for disabling it.
Comment 18 Joel Madero 2014-11-04 02:55:15 UTC Comment hidden (obsolete)
Comment 19 Joel Madero 2014-11-20 05:32:57 UTC
This is a fine enhancement request but as Kohei has said - very unlikely that a volunteer will ever tackle it. Marking as NEW as the bar for enhancements is quite low.
Comment 20 Aron Budea 2017-08-24 00:21:41 UTC
Version field is for the oldest known affected version, please don't change it to a new one, just note in a comment that the bug is still there in that version.
Comment 21 thomas 2019-06-10 12:35:16 UTC
hi! just today, 10th June 2019 (!), I switched from OpenOffice (4.1.3) to LibreOffice ( and I realize in LibreOffice Calc, that this bad feature of pasting with the enter key IS STILL THERE !!! – this bug report 34686 is dating back to 2011 !! – I am not capable in programming, but would so much appreciate, if those who can program LibreOffice implement a check box in "Preferences..." > "LibreOffice Calc" > "General" allowing to "Disable paste with Enter key"!! It would be great if the users themselves could just choose which behaviours of the enter key they like to use! It is not good that this function is not deactivatable!!! Thanks !
Comment 22 Mike Kaganski 2019-06-10 13:28:04 UTC
A reference to implementing commit: https://git.libreoffice.org/core/+/be2150398ce765b87d44ada8a13c09345be52e22, which may give an idea where to put an option check - and then expect unknown list of features mentioned in comment 2 to fail.
Comment 23 leander.holtmann 2019-09-09 11:25:18 UTC
I also switched from OpenOffice to LibreOffice recently and this Enter-to-Paste behaviour drives me crazy, as I use Enter to edit cells.
I cannot understand how anybody sees this as a useful feature, it harms workflow big time. It is so unpredictable; it even deletes the clipboard contents afterwards so you cannot just undo the accidental paste and carry on, you also have to copy again.

Btw what other features rely on this? Why did anybody implement this in the first place?