Apache OpenOffice (AOO) Bugzilla – Issue 28535
Enter key = copy
Last modified: 2013-07-30 02:36:46 UTC
It would be nice, if we could use the enter key, as a shortcut, to paste something from the clipboard.
Hi Bettina, one for you. Frank
I've installed Oo in my father's computer. The only complaint I got so far is about this "enhancement", since he was used to "another spreadsheet" behaviour. I vote for this issue
Created attachment 51424 [details] Implements the desired behavior.
An analysis of the "other" spreadsheet shows that: 1. ENTER as an alias for paste only occurs if you copy something within the spreadsheet first. Copying text to the clipboard from another application does not cause ENTER to be an alias. 2. ENTER only works as an alias the *first* time it's pressed after the copy. 3. After using ENTER in this fashion, the clipboard is cleared. The previously attached patch implements all of these behviors.
Created attachment 51674 [details] Updated patch.
The updated sc-paste-on-enter.diff removes some crashes that were present in the previous patch, and alters the behavior so that after the paste the destination cell doesn't have a black background with white text. However, I've noticed that ooh680-m7 removes this "black backround/white text" on Ctrl+V (paste) display issue, so I'm not sure if that part is necessary anymore.
Created attachment 51918 [details] Updated patch.
The most recent updated patch uses ScTabView::Unmark() instead of the (hackish) addition of an IDF_SPECIAL_NOMARKAREA flag. It also allows TAB to move the current cell if only a single cell was pasted (instead of TAB moving "between" the cells of the pasted selection, which doesn't do anything as there's only one cell in the selection).
Created attachment 63804 [details] updated patch
Created attachment 63805 [details] animated border patch (sc)
Created attachment 63806 [details] animated border patch (svx)
The last two patches are for implementing animated borders around pasted ranges.
I've opened up Issue 105628 for supporting animated borders for copied range.
re-assigning this to myself.
started.
The work is on-going in the koheicopyborder cws.
Is there a way to disable paste on enter key input and keep copied cells in clipboard? I find myself copying a cell, then I double click on another cell to check out a formula, and press enter when I'm done looking at it and it pastes a cell location into the formula and messes it all up. In windows version this does not happen and it remembers copied cells on clipboard if I double click and press enter on a cell. An option to disable this would be much appreciated. Combine this with the undo crash bug (that is now fixed) and I've wasted hours on crashed spreadsheets and being very afraid to use undo function, luckily recovery works good.
That's what I just fixed in Issue 102456.
Yes you fixed the undo crash bug. But it would still paste on enter button input wont it? I want that disabled. Although this bug report seems to indicate back in 2004 that someone wanted it enabled (press enter and it pastes content). "I find myself copying a cell, then I double click on another cell to check out a formula, and press enter when I'm done looking at it and it pastes a cell location into the formula and messes it all up."
>But it would still paste on enter button input wont it? No. Like I said, that was the bug causing the undo stack corruption, and I fixed it.
To be more specific, when you go into an input mode (i.e. double-click on a cell so that the blinking cursor is displayed), the paste-on-enter functionality is supposed to be disabled. So, in your use case, it will not paste when the enter key is pressed.
Ok Thanks. Glad two bugs were fixed (didn't know they were related) :) Hope they make it into the next openoffice version. Should 'target milestones' be set?
My tentative target is 3.3 although I have several other features targeting for 3.3 and I'm not sure if I can make this one integrated in time for 3.3. But I'll set the target later when I feel appropriate.
*** Issue 107963 has been marked as a duplicate of this issue. ***
Hi all, I would opt for an option to disable the "paste on enter key" feature. IMHO it is inconsistent with other functionalities. The "enter to switch to edit mode"; I like this option very much, am used to it. But together with the "paste on enter key" this gets very confusing: 1) CTRL+C - copy a cell to the clipboard 2) CTRL+V - paste the clipboard somewhere (another cell or even another application) and forget about it, continue working on something else 3) back to the spreadsheet, press ENTER to edit another cell not related to the previous one... and voila, the cell gets overwritten by the very first one Personally I am struggling with this trouble each and every day... Many thanks, Ivo
You can hit ESC to manually exit the paste mode.
I'm adding this comment to all open issues with Issue Type == PATCH. We have 220 such issues, many of them quite old. I apologize for that. We need your help in prioritizing which patches should be integrated into our next release, Apache OpenOffice 4.0. If you have submitted a patch and think it is applicable for AOO 4.0, please respond with a comment to let us know. On the other hand, if the patch is no longer relevant, please let us know that as well. If you have any general questions or want to discuss this further, please send a note to our dev mailing list: dev@openoffice.apache.org Thanks! -Rob
Reset assignee on issues not touched by assignee in more than 1000 days.