Issue 56938 - Need [ctrl]-["] to copy contents of cell above active cell
Summary: Need [ctrl]-["] to copy contents of cell above active cell
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2005-10-29 23:20 UTC by timdeaton
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description timdeaton 2005-10-29 23:20:54 UTC
One Excel97 feature I only recently discovered, but which I now use heavily, is
the [ctrl]-["] shortcut.  It copies TO the active cell the contents of the cell
above it.  IE: if cell A1 contains the number "12.5", and I'm in cell A2 and hit
[ctrl]-["], then "12.5" is copied to cell A2.  If cell A1 contained the function
"=b6", then "=b6" would be copied to cell A2.

It would be very helpful to have that shortcut in OpenOffice.

(In Office97, the same shortcut works in Access, copying the contents of the
same  field of the previous record.)
Comment 1 frank 2005-11-15 14:05:13 UTC
one for requirements
Comment 2 ace_dent 2008-05-16 01:42:06 UTC Issue Tracker - Feedback Request.

The Issue you raised is currently assigned to 'Requirements' pending review, but
has not been updated within the last 2+ years. Please consider re-testing with
one of the latest versions of OOo, as the problem(s) may have already been
addressed. Either use the recent stable version:
or consider trying the new OOo 3 BETA (still in testing):
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
Comment 3 timdeaton 2008-05-18 04:39:58 UTC
I just tested this in v2.4, and it does not work.  I guess it's not something
many people use, since no one else has commented on this thread.  I can
understand that, since I had been heavily using Excel for 9 or 10 years before
discovering this feature.  But once I DID discover it, I've used it probably
every day.  It would definitely be nice to have in OO Calc.
Comment 4 timdeaton 2009-10-24 17:25:22 UTC
I just tested this again in version 3.1.1, and it still is not there.  Is there
any likelyhood of getting it added in the near future?