Bug 53602 - Copy value from cell above by one button click
Summary: Copy value from cell above by one button click
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.5.4 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
: 114118 (view as bug list)
Depends on:
Blocks: Calc-Cells Cut-Copy
  Show dependency treegraph
Reported: 2012-08-16 16:38 UTC by Grobe
Modified: 2017-11-28 22:48 UTC (History)
3 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 Grobe 2012-08-16 16:38:06 UTC

I have a little feature request. I hope you think the idea is good :)

At work we have a software that we use to document the time spend at work. It looks like a spreadsheet but is not quite. It does have rows and coloumns to enter time values and other data.

The interresting stuff:
When entering data into any cells in the software, I can copy the information from the above cell simply by hitting the "/" button.

So, my experience for use spreadsheet applications is that I very often enters the same value that the cell above. And I'm sure that have a simple method to copy the cell (without the tedious methods by using mouse or arrow buttons Ctrl+C and Ctrl+V) like just pressing a rare* button would increase workflow.

* Means - how often do we actualy have a cell that start with slash character?

Of course it must be possible to turn the behaviour on and off in case a user need to enter a slash character.

With this non-common feature activated, keyboard click on active cell will have this effect:

1. Hit the / character and then Enter or Tab --> Cell will show he value from the cell above. Hit Tab or Enter will confirm and make cell content be copy of cell above.

2. Hit the / character and then another character --> Cell will threat the typed text in a common way. When another character is typed, the cell will change from displaying a copy of above cell to display the actual characters that user typed.

Thanks :)
Comment 1 Sören 2012-12-26 21:59:08 UTC
Enhancement, marked as NEW, as not implemented at the moment
Comment 2 Owen Genat (retired) 2013-11-17 23:32:26 UTC
This enhancement would appear to be requesting implementation of an equivalent to the CTRL+SHIFT+" (double quote mark) Excel shortcut that "copies the value from the cell above the active cell into the cell or the Formula Bar" as indicated here:


There is no equivalent function available under Tools > Customize... > Keyboard tab for Calc. Under the Category of "Edit" a new entry like "Copy value above" would seem to be required. The Edit Function "Fill Down" (CTRL+D) is similar but rather clunky as the cell references are adapted e.g., "=SUM(A1:A2)" becomes "=SUM(A2:A3)" rather than remaining the same. Fill Down also appears to initially hide the new cell value / selection (under Ubuntu 10.04 x86_64 running v4.1.3.2), requiring subsequent cursor movement to then edit the new value. Ideally this new function would place the cursor in the Input line against the newly copied value.

Might be a good addition for users familiar with Excel. Related AskLO thread:

Comment 3 Tim Deaton 2014-01-27 03:19:23 UTC
I just found out about the similar (but not quite the same) [ctrl]-[d] function that Owen described, and it WILL be very helpful.  But I agree that adding the [ctrl]-["] function that's been in Excel at least since 1997 would be much more intuitive for Excel users who know about it.

(I used Excel for a decade before discovering [ctrl]-["], but in the decade since discovering it I've used it almost every day.)

The main difference between [ctrl]-[d] and Excel's [ctrl]-["] is that when Excel's function copies the formula from the above cell, it does NOT adjust the formula's relative reference.

If cell B1 contained the formula "=A1"
then, selecting cell B2 and then [ctrl]-[d] would enter "=A2" in cell B2
while selecting cell B2 and then Excel's [ctrl]-["] would enter "=A1" in cell B2.
Comment 4 Regina Henschel 2017-11-28 22:48:18 UTC
*** Bug 114118 has been marked as a duplicate of this bug. ***