Bug 86049 - MENUS: Addition of keyboard shortcuts for insert and delete rows and columns
Summary: MENUS: Addition of keyboard shortcuts for insert and delete rows and columns
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords: needsUXEval
Depends on:
Blocks: Main-Menu
  Show dependency treegraph
 
Reported: 2014-11-09 01:28 UTC by Yousuf Philips (jay)
Modified: 2016-08-25 05:39 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Yousuf Philips (jay) 2014-11-09 01:28:31 UTC
As inserting and removing cells, rows and columns are the number one function used in calc, it would be useful to add keyboard shortcuts for the addition and removal of rows and columns, as a number of users are setting them themselves.

We currently have [Ctrl + plus] to adding a cell and [Ctrl + minus] for deleting a cell and i was thinking that we could use Ctrl + Insert for insert row, Ctrl + Delete for delete row, Ctrl + Shift + Insert for insert column and Ctrl + Shift + Delete for delete column.
Comment 1 Urmas 2014-11-09 01:55:27 UTC
Potencially dangerous actions should not have shortcuts.
Comment 2 Yousuf Philips (jay) 2014-11-09 02:25:33 UTC
(In reply to Urmas from comment #1)
> Potencially dangerous actions should not have shortcuts.

I dont see how it is potentially dangerous when you can undo.
Comment 3 Joel Madero 2014-11-09 16:27:12 UTC
This is a fine enhancement request but should get UX input. Marking as NEW for now and requesting UX team to have a look.
Comment 4 Cor Nouws 2014-11-12 17:38:33 UTC
Working with shortcuts, I hit Shft+Space and then Ctrl++
Or Ctrl+Shft+Space  and then Ctrl+-
or somesuch.
People working with shortcuts should need to know that, so no need to add more.
(And potential conflicts maybe)
Comment 5 Yousuf Philips (jay) 2014-11-12 17:41:54 UTC
(In reply to Cor Nouws from comment #4)
> Working with shortcuts, I hit Shft+Space and then Ctrl++
> Or Ctrl+Shft+Space  and then Ctrl+-
> or somesuch.
> People working with shortcuts should need to know that, so no need to add
> more.
> (And potential conflicts maybe)

Yep i had checked what the shortcuts for Excel by searching and they were saying the same thing of using a combination, but of course we cant include that combination in the menu. :D
Comment 6 Cor Nouws 2014-11-12 17:59:39 UTC
(In reply to Jay Philips from comment #5)
> saying the same thing of using a combination, but of course we cant include
> that combination in the menu. :D

Hmm, that's true.
Still I'm hesitant because I expect that this is quite invasive to change for heavy key board users / different platforms...
Comment 7 Yousuf Philips (jay) 2014-11-12 21:16:05 UTC
(In reply to Cor Nouws from comment #6)
> Still I'm hesitant because I expect that this is quite invasive to change
> for heavy key board users / different platforms...

Its not being changed, we are simply adding a direct means of them doing these functions to supplement the combination approach.
Comment 8 Cor Nouws 2014-11-12 23:09:18 UTC
(In reply to Jay Philips from comment #7)

> Its not being changed, we are simply adding a direct means of them doing
> these functions to supplement the combination approach.

Yes, that is clear. sorry.
I mean that it may conflict with use of the combinations in various environments.
And in editing mode of a cell, the Ctrl+DEL deletes a whole word , Ctrl+Shift+DEL the rest of a sentence. Ctrl+Ins is used for pasting ..

I'm rather undecided about this. Would really love the opinion of other heavy spreadsheet users.
Comment 9 Heiko Tietze 2014-11-13 08:40:39 UTC
(In reply to Jay Philips from comment #0)
> We currently have [Ctrl + plus] to adding a cell and [Ctrl + minus] for
> deleting a cell and i was thinking that we could use Ctrl + Insert for
> insert row, Ctrl + Delete for delete row, Ctrl + Shift + Insert for insert
> column and Ctrl + Shift + Delete for delete column.

Ctrl+Insert is an alternative for Copy (along with Shift+Insert for Paste). And the question is where you insert the new column/row - left or right. Okay, right now it's only the col left and the row above which can be added by menu.
My first idea was ctr+left/right/up/down but these shortcuts are used to jump to the next filled cell (I use it always). And together with Shift it selects the cells between the current and the next one. Alt+left/right increases/decreases the col width; we could override this IMHO.
On the other hand, it's in fact dangerous to just press two buttons and loose all data. If you don't see it immediately the undo function wouldn't help. Therefore my (non-working) shortcuts do only add cols/rows.
Putting all together I think we should keep the current behavior. If it's unclear where col/rows should be added/deleted, a dialog is shown (unclear in terms of only one or a few cell are selected). However when a column or row is selected the shortcut works immediately as expected. And the new toolbar buttons makes it very easy to modify the sheet.
Comment 10 Yousuf Philips (jay) 2014-11-14 01:35:23 UTC
(In reply to Cor Nouws from comment #8)
> I'm rather undecided about this. Would really love the opinion of other
> heavy spreadsheet users.

Yes it would be nice to get feedback from calc users, especially ones who do set these shortcuts, as some were when i look at the OOo stats.

(In reply to Heiko Tietze from comment #9)
> Ctrl+Insert is an alternative for Copy (along with Shift+Insert for Paste).
> And the question is where you insert the new column/row - left or right.
> Okay, right now it's only the col left and the row above which can be added
> by menu.

Yes these would act no different than the Insert > Row, etc.

> On the other hand, it's in fact dangerous to just press two buttons and
> loose all data. If you don't see it immediately the undo function wouldn't
> help. Therefore my (non-working) shortcuts do only add cols/rows.

Yes that sounds like a first good step of just doing the insert ones.

> Putting all together I think we should keep the current behavior. If it's
> unclear where col/rows should be added/deleted, a dialog is shown (unclear
> in terms of only one or a few cell are selected). However when a column or
> row is selected the shortcut works immediately as expected. And the new
> toolbar buttons makes it very easy to modify the sheet.

Yes i believe the toolbar buttons will definitely help users avoid going to the menu, but heavy spreadsheet users are heavily into shortcuts and it would be good to assign an appropriate shortcut for these insert operations, rather than them doing shortcut combinations.
Comment 11 m.a.riosv 2015-11-21 15:23:42 UTC
BTW, the choice after [Ctrl][+] / [Ctrl][-], remains up to the next LibreOffice session.
In addition to c#4, selecting columns/rows with the mouse plus [Ctrl][+] / [Ctrl][-] works just fine, I think less prone to unwanted errors.

Perhaps could be closed.
Comment 12 Robinson Tryon (qubit) 2016-08-25 05:39:06 UTC
We're replacing our use of the 'ux-advise' component with a keyword:
 Component -> LibreOffice
 Add Keyword: needsUXEval

[NinjaEdit]