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.
Enhancement, marked as NEW, as not implemented at the moment
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 v220.127.116.11), 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:
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.
*** Bug 114118 has been marked as a duplicate of this bug. ***