Issue 38108 - calc K/B shortcuts
Summary: calc K/B shortcuts
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 1.1.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: frank
QA Contact: issues@sc
: 2842 30590 (view as issue list)
Depends on:
Reported: 2004-11-30 04:49 UTC by einstienindia
Modified: 2013-08-07 15:14 UTC (History)
5 users (show)

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

Proposed patch (698 bytes, patch)
2004-11-30 04:54 UTC, einstienindia
no flags Details | Diff
patch (2.50 KB, patch)
2007-05-28 15:05 UTC, mmeeks
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this issue.
Description einstienindia 2004-11-30 04:49:47 UTC
To make the transition from MS office to OO as easy as possible, OO 
should include the keyboard shortcuts of MS Office, e.g. <ctrl> +/- to 
insert/delete a complete line in calc.
Comment 1 einstienindia 2004-11-30 04:54:11 UTC
Created attachment 19893 [details]
Proposed patch
Comment 2 frank 2004-11-30 09:24:50 UTC
Hi Bettina,

one for you I think.

Comment 3 mmeeks 2007-05-28 15:04:32 UTC
Since we had no comment in 2+ years I though I'd take the liberty of adding the
latest patch here for comment. Is 'bh' still working on calc ? ...
Comment 4 mmeeks 2007-05-28 15:05:22 UTC
Created attachment 45465 [details]
Comment 5 erack 2007-05-30 23:03:55 UTC
'bh' is a member of the UX team and somewhat was the predecessor of the
requirements queue.. as this issue previously wasn't of type PATCH it probably
drowned in the mass of other RFEs.

Not sure about the attached patch, besides assigning (<shift>)<ctrl><+>/<-> to
insert/delete cell it also changes ctrl+1 from SpacePara1 to FormatCellDialog,
which is fine I think, but also changes ctrl+D from DataSelect to FillDown,
leaving DataSelect non-accessible. Personally I almost never use DataSelect though..

@nn,@bh: any opinion?
Comment 6 niklas.nebel 2007-05-31 10:16:45 UTC
Ctrl-1 is in CWS "dr54" (issue 35738).
DataSelect (now Ctrl-D) certainly has to remain available as a shortcut
(possibly a different one). It's the only way to select DataPilot page fields by
keyboard (accessibility requirement).
I'm fine with Ctrl-Plus and Ctrl-Minus, but we won't add them without agreement
from User Experience. The patch also adds Shift-Ctrl-Plus, I suppose that wasn't
Comment 7 bettina.haberer 2007-05-31 11:38:29 UTC
Yes, Ctrl-Plus and Crtl-Minus are useful to add / delete rows and columns. Let's
take those both shortcuts. 
I suggest, if a row- or column-header is selected, Ctrl-Plus and Ctrl-Minus add
or remove the row or column. 
And if one cell is selected, Ctrl-Plus opens the dialog 'Insert Cells', and
Ctrl-Minus opens the dialog 'Delete Cells'.
Comment 8 niklas.nebel 2007-06-08 10:07:28 UTC
Oh, Shift-Ctrl-+ for non-numpad + on a US keyboard.
That's more of an ugly hack than a solution - it bypasses the Customize dialog,
it's specific to some keyboard layouts, it's inconsistent with other shortcuts
(Ctrl-*, Ctrl-/).
I included it for now (in CWS "dr54"), but I still think a better solution is
Ctrl-D is still open, I reopened issue 67029 for that.
Comment 9 niklas.nebel 2007-06-13 10:31:27 UTC
reassigning to QA for verification
Comment 10 frank 2007-07-02 08:27:33 UTC
found fixed on cws dr54 using Linux, windows and Solaris build
Comment 11 kendy 2007-07-17 14:02:55 UTC
Comment 12 frank.loehmann 2007-07-23 10:35:46 UTC
*** Issue 30590 has been marked as a duplicate of this issue. ***
Comment 13 niklas.nebel 2007-07-23 10:48:25 UTC
*** Issue 2842 has been marked as a duplicate of this issue. ***
Comment 14 frank.loehmann 2007-07-23 10:57:31 UTC
*** Issue 2842 has been marked as a duplicate of this issue. ***
Comment 15 docb 2007-10-17 13:59:23 UTC
To make it even more compliant: If a column/row is selected for the clipboard, a
crtl+ should paste it into the new line. and if another crtl+ would paste the text would be even better than in MS-Office (it supports pasting only once).

Can that be added as well?