Issue 67029 - Fill Keyboard Shortcuts
Summary: Fill Keyboard Shortcuts
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-07-04 21:34 UTC by phentax
Modified: 2017-09-27 19:07 UTC (History)
4 users (show)

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

Attachments
The patch we use in ooo-build. (1.19 KB, patch)
2007-07-17 13:56 UTC, kendy 		no flags Details | Diff
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description phentax 2006-07-04 21:34:43 UTC 
Open Office does not allow filling down or right using keyboard shortcuts. 
Requires a way to emulate fill fuctions found in MS Excel or at least allow 
user to map keyboard shortcuts in calc.
Comment 1 gercokees 2006-07-11 14:05:30 UTC 
Hi,
I do not know about fill functions found in MS Excel. Can you supply an example?
Second, there is a way to map keyboard shortcuts in calc (2.0.3):
> Tools > Customize > Keyboard

Gerco-Kees
Comment 2 phentax 2006-07-15 15:00:47 UTC 
Hi Gerco-Kees,
    In MS Excel, a user can highlight a source cell and intended fill ranges
then use keyboard short cut (Ctrl-D [for fill down] or Ctrl-R [for fill right]).
Currently in Calc the same proceedure brings up a 'dropdown' box with the first
highlited cell, which only fills the last highlighted cell when clicked.

Of course the proper fill function occurs when the user uses the mouse to fill
cells (ie. clicking on bottom right corner of highlighted cell and dragging to
other cells) but this defeats the purpose of the keyboard shortcut.

Another side issue related to this is the default method that the fill works
(regardless of mouse drag or future keyboard shorcut). If there are no numbers
then the fill clones the cells, but if there is a number then the fill creates a
series. Would there be a way to customize the way this works, so the user can
pick which default fill method?

Thanks again for all your help.
Comment 3 delorea 2006-07-21 14:53:10 UTC 
You can customize keyboard.
So when you customize your Ctrl-D and Ctrl-R (we need only one key because the
function is the same) you can choose Edit-Autofill Data Series or Edit-Fill
something.
Fill Series is used to modify the way autofill fill cells. You can specify for
example the step in arit. series.
If is ok for you we can close the issue.
Try and let us know.
Comment 4 frank 2006-07-27 10:54:26 UTC 
double to Issue 35738

*** This issue has been marked as a duplicate of 35738 ***
Comment 5 frank 2006-07-27 10:54:52 UTC 
closed double
Comment 6 niklas.nebel 2007-06-08 10:03:16 UTC 
Reopening because issues 35738 and 38108 only add the other shortcuts. Ctrl-D
conflicts with the selection list. A different shortcut has to be selected for
either "fill down" or the selection list.
Comment 7 niklas.nebel 2007-06-08 10:04:34 UTC 
Reassigning to requirements.
Comment 8 kendy 2007-07-17 13:56:42 UTC 
Created attachment 46862 [details]
The patch we use in ooo-build.
Comment 9 kendy 2007-07-17 13:57:17 UTC 
Issue type: PATCH.
Comment 10 frank 2007-07-18 15:14:58 UTC 
Hi Niklas,

as it is a PATCH now, please have a look at it.

Frank
Comment 11 niklas.nebel 2007-09-10 12:55:43 UTC 
As already mentioned, we can't change that shortcut without a solution for the
selection list.
Comment 12 Marcus 2017-05-20 11:11:40 UTC 
Reset assigne to the default "issues@openoffice.apache.org".
Comment 13 oooforum (fr) 2017-09-27 19:07:42 UTC 
I set status as patch
I don't know if this works with AOO 4.x