Apache OpenOffice (AOO) Bugzilla – Issue 38108
calc K/B shortcuts
Last modified: 2013-08-07 15:14:03 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.
Created attachment 19893 [details] Proposed patch
Hi Bettina, one for you I think. Frank
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 ? ...
Created attachment 45465 [details] patch
'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?
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 intended?
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'.
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 needed. Ctrl-D is still open, I reopened issue 67029 for that.
reassigning to QA for verification
found fixed on cws dr54 using Linux, windows and Solaris build
Closing.
*** Issue 30590 has been marked as a duplicate of this issue. ***
*** Issue 2842 has been marked as a duplicate of this issue. ***
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 again...it would be even better than in MS-Office (it supports pasting only once). Can that be added as well? Thanks!