Apache OpenOffice (AOO) Bugzilla – Issue 56938
Need [ctrl]-["] to copy contents of cell above active cell
Last modified: 2013-08-07 15:12:27 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.)
one for requirements
OpenOffice.org 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: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ 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: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html
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.
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?